Can someone explain what it means to use this in the table relation for BAQ’s. I had been trying to make a BAQ for days but couldn’t get it right. Thought I would check if someone’s made a similar BAQ in the past and luckily, I found exactly what I needed. I do not understand what is happening in the table relations though.
In that table, the key is the following:
Major component of the foreign key of the related master record. For example: For a “Part” control this field would contain the related Part Number, for a “Customer” it contains the Customer.CustNum.
1 Like
I did read that in the data dictionary but did not quite understand it. Since it is connected to the vendor table, it is using the VendorNum in this scenario? If I were to use a different table, i would use the foreign key for that table? Sorry I had to dumb it down for myself to understand.
Table relations will usually fill themselves in, but they are the variables you use to connect A table to B table. Most tables it will be the Company, and one of the Primary Keys for that table, for example Part’s primary keys are Company and PartNum. Your query is joining the EntityGLC and Vendor tables, checking the Key1 field against the VendorNum casted as an integer, and then if they match it’s returning both, and if they don’t it’s still returning the EntityGLC row without the Vendor data per the join type.
Ohhhh okay, I think I get it now. Thank you so much for the explanation. I appreciate it,
1 Like