Populate fields using data from different tables

[cgreyes]

Good morning - I know very little about Access but need to create a database for work. I was hoping there would be a way to select an id based on a previous table and have parts of it populate in this new table.



For example:

Table A - Webinars (Webinar ID, Webinar Title and Client)
Table B - Sessions (Session ID, Date, Webinar Title, Time, Facilitator, Session Occurred, Reason, Conference Call) [Webinar Title I used a look up field and just select the corresponding Webinar Title and it works nicely]
Table C - Users (User ID, Status, Prefix, Last Name, First Name, Email Address, Component, Role and State)
Table D - Registrants (User ID, Session Date, Webinar Title, Attended).

So in Table D I would like to add Role and Component, so when I select User ID #1 the Role and Component Field populate with the info based on Table C.

Does that make sense is there a way it can be done simply?

Thank you.

[orange]

Your proposed tables are not normalized and will be an issue.

Before getting in to the details of Access tables, I recommend you do a little reading on Normalization and database design. Here is a link to a relatively short article that may help you.
http://www.google.com/url?q=http://f...CVdHsFu8UhWF2g

[cgreyes]

Hi, I read it, but did not understand it. The database works for the most part. A couple of queries I'm trying to figure out. But the article did not help

[orange]

Well, your tables are not normalized, try this link to assist in designing your tables

http://www.rogersaccesslibrary.com/T...lationship.zip

The full design stuff is here http://www.rogersaccesslibrary.com/forum/topic238.html

see Post #15 here, https://www.accessforums.net/forms/i...orm-21571.html
for videos on normalization and table design

Good Luck.