Autofilling address etc.

[ptcruiser]

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.

[The Shadow]

Hi Spence,

Here's a sample file showing how to set this up with related fields, so no data is actually copied. The pop-up chooses a supplier, and you see their info on the same form, but no copying is occurring.

Shawn

RelatedExample.fp7.zip

[ptcruiser]

Thanks Shawn - I'll give it a go :thumbup:

[ptcruiser]

Thats just what I needed - I've spent 2 days fretting over this. I was given this as a task in my new job (not as a database person (don't worry ).

Thank you so much!