By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Foreign key field on form

P: n/a
Guys,

I'm sure this is pretty easy, I just can't figure out the correct
terminology to do a search for it.

What I need is basically a text field on one form which is based on
table A, and which displays a field from table B. Table B has a
foreign key field from table A. There will be multiple associated
records in table B, but the one that should be displayed has a
specific boolean field set to true.

Thanks,
Thomas
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
DLookup is what you want.

Punctuation for the 'where clause' depends on datatype so careful.

Dlookup("LookedupfieldName","TableB","ForeignKeyFi eldOnTableB =
ValueOfTableAKeyfield")

Regards

Peter Russell

17028 previously wrote:
Guys,

I'm sure this is pretty easy, I just can't figure out the correct
terminology to do a search for it.

What I need is basically a text field on one form which is based on
table A, and which displays a field from table B. Table B has a
foreign key field from table A. There will be multiple associated
records in table B, but the one that should be displayed has a
specific boolean field set to true.

Thanks,
Thomas


Nov 12 '05 #2

P: 1
Where does that go? Does it go in the Control Source, Row Source, or somewhere else?
Jun 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.