Help with a dropdown list (1 Viewer)

[sajarac]

Hello guys, hope someone can point me in the right direction:

I have a database with assessments, each record is a building assessment an a customer could have several buildings the problem is when the database was developed I use a record for a building meaning customer will appear several times depending on how many buildings are, now I cannot fix this structure, what I am planning to do is to create another table with all of the buildings and link to a specific record, but I have another tables and I would like to retrieve in those tables the building names that belong to the records in a drop down list, and I don't know how to achieve this

Any help will be gratefully appreciated.

Regards

Sajarac

 

[Ranman256]

Yes, all the buildings only need a OwnerID.

The tAssess table will need fields:
BuildingID, Assessment, result

...To have several assessments per building.

 

[sajarac]

Hello, and thank you very much for your prompt reply, unfortunately I am not an expert as you and I can't figure out. so far I have the first part already done, but I am having hard time trying to get the data in every table using the dropdown option.

Could you please let me know if you can provide a 1/2 session? I am willing to pay.

thanks again.

Regards

Sajarac

 

[jdraw]

See the links in this post for more info on database
https://access-programmers.co.uk/forums/showpost.php?p=1516588&postcount=7