MS Access......USING relations to populatle fields

[Professor0210]

I'm out here in Baghdad, new to Access, without manuals needing to use Access to perform a task. I need to populate certain fields on one table with fields from another table.

I've learned how to set up a relationship, but that's it. How do I fillin a userid in one table and get the user's info filled in on this table with info from another table?

Is that clear as mud?

Thanks.

 

[JGillespie]

quick answer is you don't unless absolutely necessary. you don't need to store the same information in two tables.

can you be a bit more specific in what you are looking to do?

Jamie Gillespie
j-gillespie@s-cheshire.ac.uk

 

[BNPMike]

Firstly relationships don't really do anything, so don't expect any help there.

Bring the two tables into to the Graphical Query-by-Example Screen. If your relationships haven't pre-drawn a join line between the userid fields in each table then do so now.

Select all the fields that are either going to receieve data or are going to provide it. Press the button and see if everything looks right.

Now change the query to an update query (using the toolbar). Now for each field you want loading, put the name of the corresponding provider field into the update line eg if newtable.haircolour is going to be loaded from oldtable.hcol then put [oldtable.hcol] under [newtable.haircolour].

That's it really. Make sure you take a back-up of your database before you do major updates.

 

[Professor0210]

What we're trying to do is use Access to create a ticketing system for trouble calls. one table for the actual work tickets, one table for the user data information.

 

[glalsop]

Firstly relationships don't really do anything, so don't expect any help there.

I disagree, relationships are very important.

JGillespie's assessment seems to be accurate.
Add the UserID field to the WorkTicket table.

To view all of the information in a report, create a query to show you the information about the person on the work order.

Good luck


-Gary