one to many relationship: changing the values in 1 table to match another

[Nimo]

Hey,


I have two tables, one has a list of feels related to transactions: Transaction ID, transaction type, landlord name, and tenancy.



The second table has 2 fields: landlord ID and landlord name...

As u can see I have the landlord name in the transaction table, but I dont want the table to display the landlord names, I would prefer if it displays the corresponding landlord ID from the second table but I cant seem to figure out how.. Can someone help ?

[burrina]

Typically you have a Fake Key and relate it to the Primary Key when linking tables. Or you use a Lookup table via the Fake Key. Example:
tblTransaction will have a Fake Key LandlordID and then use this to Lookup the Landlord in tblLandlord
HTH

FYI: I did not mean to recommend a Lookup in your table, just using a Combobox as an example.

Good Luck With Your Project!

[June7]

I have deleted your duplicate thread. Please do not post duplicate threads.

Use a combobox to select landlord and save the LandlordID into transaction table. Review http://www.datapigtechnologies.com/f...combobox3.html

I NEVER build lookups in tables. http://access.mvps.org/access/lookupfields.htm

Build and form for data entry/edit. Maybe even form/subform http://office.microsoft.com/en-us/ac...010098674.aspx