Retrieving linked data from tables

[MarkWaddington]

I'm positive this is a simple query, but it eludes me.

I have a table entitled Projects which has a field called ProjectPrefix that has a one-to-one link with another table called Project_Prefix which contains the fields ProjectPrefix and ProjectDescription.

Now I am trying to get a field on my Project form which displays the corresponding ProjectDescription. In the past I have just added a sub-form and let the wizard do the rest. This worked ok until today when I realised I would need a CONTINUOUS form.

Apparently you cannot have sub-forms on a continuous form so I am at a loss as to how to make it display this ProjectDescription field.

Please help!

Many thanks.

Mark Waddington.

 

[KenReay]

HI

Make a query with The two tables (project and project_Prefix) with a join on ProjectPrefix, include all columns from project, in the 'show' portion of the query, plus the column ProjectDescription from the prefix table.

Use the above query as the recordsource for your continuos form Regards

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

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

UK

 

[MarkWaddington]

Hey thanks! Knew it would be simple