Auto Fill

[Sam A]

I have four tables which hold various pieces of data about
individial companies. The information in these tables
changes and I use a query to pull all the info together to
just look at the latest piece of info for a company.

My problem is that I need to use this queried information
in a data entry order form. When I select from a drop down
the company name, I would like the queried info - four
fields of data - to appear as a reference. Then have the
order details entered thereafter.

I cannot seem to get this to work.

I tried to look at the info as subform - but you can't do
continuos forms. I tried creating a table from the query
but that didn't seem to work either.

I think it's something simple but I'm having a total blank.

Please help me!
Sam

 

[Tim Ferguson]

I have four tables which hold various pieces of data about
individial companies. The information in these tables
changes and I use a query to pull all the info together to
just look at the latest piece of info for a company.

I am not clear about the design here: how are the tables related? There
is very rarely^W^W practically never any reason to have loads of 1:1
relationships chopping up what could be a single record.

My problem is that I need to use this queried information
in a data entry order form. When I select from a drop down
the company name, I would like the queried info - four
fields of data - to appear as a reference. Then have the
order details entered thereafter.

Four fields or four tables? You can certainly use the AfterUpdate event
of a combo or list box to adjust the .Recordset of the form, or move the
form pointer to the correct record. But you have to make sure you have a
sensible schema design first.

Hope that helps


Tim F