Form Wizard Generates Blank Form??

[awrex]

I have 3 tables that I'm referencing to generate this form. I've narrowed it
down to one troublesome table (tbl_mailstop) but not certain as to why it's
this table that is causing the problem. It only has four fields three which
are number data type and the last one is text, which is the only field on
this table that I'm using on the form.

Any ideas???? Thanks!!

Here's the Record Source..
SELECT tbl_K.Con_ID, tbl_K.F_Name, tbl_K.L_Name, tbl_K.M_Name, tbl_K.Alias,
tbl_K.K_ID, tbl_K.Desk_phone, tbl_K.Cell_Phone, tbl_K.Pager, tbl_K.BranchID,
tbl_K.KCatID, tbl_K.RoleID, tbl_K.Hire_Date, tbl_K.Start_Date,
tbl_K.End_Date, tbl_K.Lap_Make, tbl_K.Lap_Serial, tbl_K.Lap_Date,
tbl_K.Lap_Memo, tbl_K.Novell_ID, tbl_K.Con_Agmt, tbl_K.FTP_H, tbl_K.Pgr_Pin,
tbl_K.Pgr_sec, tbl_K.Pgr_email, tbl_K.Pgr_cc_sn, tbl_K.K_email, tbl_K.K_Mgr,
tbl_K.K_PM, tbl_K.Tgt_Asmt, tbl_K.C_mem, tbl_K.T_ID, tbl_T.Project_ID,
tbl_T.PeopleSoft_ID, tbl_T.LAN_ID, tbl_T.TSO_ID, tbl_T.TSO_Phone,
tbl_T.RAS_Seri, tbl_T.RAS_Issue, tbl_T.RAS_Exp, tbl_T.Pere_ID, tbl_T.BldgID,
tbl_T.DeptID, tbl_Mailstop.Mailstop, tbl_T.Cubi, tbl_T.T_email, tbl_T.T_PM,
tbl_T.Rem_Pro_Time FROM ((tbl_Dept INNER JOIN tbl_Mailstop ON
tbl_Dept.DeptID=tbl_Mailstop.DeptID) INNER JOIN tbl_T ON
tbl_Dept.DeptID=tbl_T.DeptID) INNER JOIN tbl_K ON tbl_T.T_ID=tbl_K.T_ID;

 

[Damian S]

Is there data in each of the three tables? You have used INNER joins, which
means that if there is no matching data in one of the tables, nothing will be
returned, which might explain why the wizard doesn't work... If this is the
case, try using LEFT joins...

Of course, you could try building the form without the wizard...

Hope this helps...

Damian.

 

[awrex]

I have the relationships all mapped out and the wizard should work but I
don't know why it's not?

I have tbl_k with a many to 1 relationship to tbl_t. Tbl_t has a many to 1
relationship to tbl_dept and tbl_project. Tbl_dept has a 1 to many
relationship to tbl_mailstop.

Now I'm trying to use a field in tbl_mailstop in the form, which is linked
to tbl_dept. Do I also need to make a link from tbl_mailstop to tbl_t or is
the link from tbl_dept to tbl_t enough?

 

[martdi]

If you insert data coming from more than two sources, the wizard will
generate a blank form most of the time. I think there is not much you
can do about it, but creating the form in creation mode.