Hi all, I am a complete novice when it comes to databases, however I was able to create a form and wanted to add fields such as supplier name, address, tel etc. from another table within the same database. I set the supplier name field that uses a drop down list to pick a supplier (successfully) and then wanted it to fill in the rest of the supplier details (address, telephone etc).
I have created the main form and also created a secondary table/form with suppliers on. However I can't seem to get them to autofill (if that is the right terminology...any ideas?
....its really bugging me this issue - I can get it to look up a single field from another table, but can't then get it to autofill the related fields (address etc.)
Help...please - is there an example file out there that basically has a dropdown list for the name (linked to another table) and once selected will then fill in an address field etc.? I am sure a simple example will get me back on track.