Update a new column where f_name and l_name match.

[perelo]

I´m trying to update my boatclub members database, the problem is this:
The members table is imported from excel and it looks just like I want it except that it hasn´t any information about the members boatwidth. That info is in another excel-file that I´ve imported as a new table without problem.

My intention is to match the table members.f_name and members.l_name against width.f_name and width.l_name and when there´s a match I want the width.boat_width to update members.boat_width.

What next? Do I need to setup relations?

Regards, Per Elofson, Sweden

 

[Remou]

Hi
You can create this in the query window by dragging members.l_name across to width.l_name and members.f_name across to width.f_name. In SQL view, this will look something like:
[tt] <...> FROM tblMembers INNER JOIN tblWidth ON (tblMembers.L_Name = tblWidth.L_Name) AND (tblMembers.F_Name = tblWidth.F_Name);[/tt]

I guess your database is quite small and does not contain two people with the same name.

 

[lespaul]

what are you going to do when there are two Bob Jones in your database? Maybe you should find some other field to join on instead of First and Last Names.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design