lookup and prefill table fileds.

[the1gofer]

I'm not exactly sure how to phrase this question, so I apologize in advance if i'm not as articulate as I should be.



If I have table structure like this https://www.dropbox.com/s/5qicd17zyn...ture.PNG?raw=1. Is it possible to to have some fields flow from one to the other? If we start with submissions, as smaller subset with become bound. We already have some of the information we need in the submission table, so can we get that to flow over when filling out the bound table. For example, lets say we have a submission for bob smith. bob smith decides to bind, then when we are filling out the bind details, we do a lookup for names (I know how to do that) and the user selects bob smith. When bob smith is selected, then it pulls in the submission number.

I realize i could run a query and get all that data in one place, but for the person entering the data it would be less prone to error if things just flowed.

[ranman256]

when user enters the customer, (via combo box, id or name) the afterupdate event triggers the append query to fill in the fields for that record.
(the user does nothing)

[the1gofer]

when user enters the customer, (via combo box, id or name) the afterupdate event triggers the append query to fill in the fields for that record.
(the user does nothing)

Thank you. I'll take a look into that. I'm assuming it's a VB script?

[pbaldy]

If appropriate this might be simpler:

http://www.baldyweb.com/Autofill.htm