Pulling through records

[Crampton]

Bit simple question this but i really cant make it work......

I have 2 tables one called Company Database the other called Company History.
I have set up a relationship ( one company database to many company history )
When using Company Database, I have used a lookup wizard and asked it to look up the values in the history database. when i select an company name it does not pull the through the rest of the company details like address etc.

I would like to be able to select a company name in one table and for Access to pull through the rest of the data on another.

I have a copy of the database if that helps anyone.

All help very much appreciated.

 

[FoFa]

Not sure how yours is setup, but typically you have say a combobox to select your company, usually based on a query. The user would select a company, than you would use a filter/query ona form or something that used the value of the combobox selection, and requery form or whatever after the selection. Key words here are REQUERY and VALUE OF COMBOBOX SELECTION

 

[Crampton]

Thanks FoFa for that help, it seems to have solved it, thanks again