Joins

[dr223]

Hi there,

Consider 2 simple tables

Name ID Pet
A 00 dog
B 11 cat
C 22 hamster

Name ID hasJob
A 00 no
B 11 yes
D 33 yes

how do I make a join to get this table?

Name ID Pet hasJob
A 00 dog no
B 11 cat yes
C 22 hamster --
D 33 -- yes

Help much appreciated.. thank you

 

[Moniker]

Well, how do you think you join the tables? What have you tried? What issues did you run into?

 

[dr223]

I made a query and joint two tables payer_det and payer_lkup, with the payer_code and created the join.

To bring forward the HESA, fin_code and fees_remitted

When I run the query the results are fine.

Now, how will I make the above fields (HESA, fin_code and fees_remitted) be recorded on the payer_det table. At present they are all blank regardless if I create a new record.

What I want is when the payer code is added to the main form, the HESA, fin_code and fees_remitted are automatically filled on the payer_det table.

Thanks

 

[Moniker]

I'm sorry, but with the abbreviations, I can't make out what you mean. You're trying to do something simple, but it's being complicated by a lack of detail here. Can you post the DB?