I have a table with a large list of names and addresses. I do not want this large table in my database, so I linked it from another.
I want to be able to have a drop down on a form with the names. Once the name is selected, the user would click a button that will bring it to another form and pre-populate the name and addresses and allow them to enter additional information for that company. The data would then populate into a table that is stored in this database.
I have attached a test database (along with the linked table database) using the logic I have described above.
There are a few issues:
1. The company name disappears from the drop down, then overwrites the linked table name with the unique identifier
2. The data form does not open with the correct data displayed.
Can anybody help me with this?
Thanks.
I want to be able to have a drop down on a form with the names. Once the name is selected, the user would click a button that will bring it to another form and pre-populate the name and addresses and allow them to enter additional information for that company. The data would then populate into a table that is stored in this database.
I have attached a test database (along with the linked table database) using the logic I have described above.
There are a few issues:
1. The company name disappears from the drop down, then overwrites the linked table name with the unique identifier
2. The data form does not open with the correct data displayed.
Can anybody help me with this?
Thanks.
