I have a set that contains a table called work order (dbf), and a table called depot (dbf) and a table called Vendor which is an active link table to a SQL Server Table. Work Order is the primary table, depot is linked to workorder on a field called DPONumber and Vendor is linked to depot on a field called VendorID. The form has a Record list Combo Box called Vendor. It is set up with the data to be the vendor active link table and the display field is name and the data field is VendorID. The combo box itself works fine in that you can select a vendor ACME Products for example, and it will put that vendors ID # (123 for example in the database). If you save the record and look at the table everything looks fine. When you open the form and pull up the same record, the record list combo box displays the first record in the drop down. But if you look at the underlying table the correct number is in the field (123). I added some type in fields on the form. One was the same field VendorID that was a type in field. The type in field displays the correct number but the combo box still shows the first record in the list in the vendor table rather than the record that 123 points to which is ACME. I went further and added additional fields from the vendor table and they all display properly. In fact if you change the vendor, the additional fields such as address and telephone change to that of the new vendor. The record list combo box will also show the correct vendor name after the change. However when you close the form reopen it and then select that record, it has the same behavior as before where it only displays the first record in the vendor table and not the vendor that is actually assigned to the record. Again the type in field that points to the same field (vendorid) shows the correct id number as well as the address and telephone which come from this same child table in the set all display fine.
It seems that for reasons I can not understand that Record List Combo Box will not display the correct �choice� when used with an active link table. Note that I never see this problem when using this type of control with all DBF tables. I actually have several controls where I am seeing this problem however.
Any help would be greatly appreciated
It seems that for reasons I can not understand that Record List Combo Box will not display the correct �choice� when used with an active link table. Note that I never see this problem when using this type of control with all DBF tables. I actually have several controls where I am seeing this problem however.
Any help would be greatly appreciated