Lookup field populates every record

[FredaChapman]

I have just rearranged a database into more tables using Analyser, as I needed more fields than 255. So far so good, I have the query produced by Analyser and use that with the original forms.

The original table had 2 lookup fields. One works fine. The other: when I enter new data into the lookup field in both the query and the form it puts the same new data in every record. I have tried different join types in the query but it does it with them all.

Any ideas? Thanks.

 

[KenReay]

Hi

Is this in a continuous form?

Is it actually populating all rows in the table?, or is it just on the form

Could be you have forgotten to bind the control to the 'main' table?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[FredaChapman]

Ken, thank you for your response.

I have to admit I don't know what a 'continous' form is; this one includes tab pages, and the control for the troublesome fields are on a tab page.

I've just checked your second point and it doesn't seem to be happening in the "main table" (which is one of several I made when I used analyser to break up the large table).

The form's record source is the "analyser" query. The combo boxes' record sources are fields in one (only) of the new tables made with Analyser, which is I think the "one" of a "one-to-many" join.

Thanks if you can help.

Freda