Outer Join with Blank Field

[ck1999]

Is their a way to do a left join and if their is not an entry in the right table to have the computer to add a recordset to the right table?

I have a form populated with this outer join and am not able to edit the data stored in the right table if there is not a current record in that table.

Hope this make sense.

Chris

 

[PHV]

Something like this ?

http://www.tek-tips.com/viewthread.cfm?qid=1053292

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

Short answer ... Yes, there is a way.

Somewhat longer answer ... Yes, but you need to have values to insert into the right table.

Just inserting values (check out the INSERT INTO statement) is straight-forward but in most business applications you probably won't have correct values available to insert at the point at which you want to do this. If you did have them then presumably they would have been inserted at some other point in the process. The fact that you have this requirement may indicate that you have a foreign key dependency that is not being enforced and you need to look at the design of the database.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]