Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Blank Record To Show Up In DataWindow

Status
Not open for further replies.

FontanaS

Programmer
May 1, 2001
357
US
I have nested datawindow that is linked to the primary one by user_id. Both are tables.

The problem is that if there are no information in the child datawindow, nothing shows up. I would like the fields to show up so the user can enter data into them.

How do I get a blank record to show up in the child datawindow for user entry?

THANKS!
 
What you need to do is go to the SQL view of the datawindow and then click on the join. When the join window opens select the join that says: = table_1.user_id = table_2.user_id and rows from table_1 that have no table_2

This should fix your problem and still list data from the first table even if there is no data entered in the child table. Hope this helps

Tentacle
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top