Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [TheStone] Add record to related table?

Quote Reply
Re: [TheStone] Add record to related table? In reply to
Hi, thanks for the reply. I know how to bring up the two tables using db and sdb and I know how to call the table using sdo. I think that my problem might be with my template for the second table. For some reason I cannot add a record to the second table. When I try I get: "

You can't add or change a record which is required by a related record in table "tblClients"."

What I think is happening is that the second template is not "talking" to the second table (if talking to any). I get unknown tags when I try and parse data to it. I am using <font class=boxhead><%ClientID%></font> to parse data and I am using <font
face=Tahoma,Arial,Helvetica size=2><input name=Date value="<%if Date%><%Date%><%endif%>"></font> to post data. On the master table's template, this works fine.

Do I need to specify which table to talk to in the second template? (I thought this was done with the link (db=*&sdb=*)).

When I use the default template, everything seems to work fine.

Please help.

Thanks.
Subject Author Views Date
Thread Add record to related table? useruseruser 2879 Jan 10, 2003, 5:54 PM
Thread Re: [useruseruser] Add record to related table?
604 2771 Jan 13, 2003, 11:05 AM
Thread Re: [TheStone] Add record to related table?
useruseruser 2758 Jan 13, 2003, 2:48 PM
Thread Re: [useruseruser] Add record to related table?
604 2769 Jan 13, 2003, 2:59 PM
Post Re: [TheStone] Add record to related table?
useruseruser 2753 Jan 13, 2003, 3:38 PM