D
Design by Sue
I have a list of Company Names in the CompanyTbl., sush as AAAA, BBBB, CCCC,
DDDD, EEEE, FFFF. The CompanyPartTbl keeps track of a PartNumber and the
Companies that use that part. For example, PartNumber 12345 can be use be
Companies AAAA, CCCC, and DDDD. I have a continuous form as a subform with a
combo box that uses the CompanyTbl as the row source, so the user can assign
the companies to a given part. I would like to create code or a query for
the row source that bases the next record on the companies not already
assigned to a part number. So in my example, the fourth record would limit
the choices in the combo box to BBBB, EEEE, and FFFF.
I have been able to create a query which displays the companies that use the
part number, (in my example, shows AAAA, CCCC, and DDDD.) and am wondering if
there is a way to base another query on the first which gives the remaining
names. Basically all records in the CompanyTbl minus the query results. Or
is there another way to accomplish this.
I am not on the computer where I am doing this work so I can't post my query
tonight, but wanted to see if anyone could reply based on my description.
DDDD, EEEE, FFFF. The CompanyPartTbl keeps track of a PartNumber and the
Companies that use that part. For example, PartNumber 12345 can be use be
Companies AAAA, CCCC, and DDDD. I have a continuous form as a subform with a
combo box that uses the CompanyTbl as the row source, so the user can assign
the companies to a given part. I would like to create code or a query for
the row source that bases the next record on the companies not already
assigned to a part number. So in my example, the fourth record would limit
the choices in the combo box to BBBB, EEEE, and FFFF.
I have been able to create a query which displays the companies that use the
part number, (in my example, shows AAAA, CCCC, and DDDD.) and am wondering if
there is a way to base another query on the first which gives the remaining
names. Basically all records in the CompanyTbl minus the query results. Or
is there another way to accomplish this.
I am not on the computer where I am doing this work so I can't post my query
tonight, but wanted to see if anyone could reply based on my description.