Gents And Ladies, I've got a hug

[bikebanditcom]

Gents And Ladies,

I've got a huge problem with my relationships, i've got a CustInfo table, that has three fields, CustID, CustName, and Email. I have also created an OrderInfo table and with many fields, you can see my entire table listing here

http://intellending.com/tables.htm

and the relationship is here

http://intellending.com/relations.htm

When i open tblCustInfo i try to expand the subdatasheet and get the msg

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by using variables."

wtf is that? if i open tblOrderInfo, i can expand the subsheet to view the parts for each order, however it won't work at the customer level. My tblEmpInfo expands to show all the transactions from tblTransInfo. Just CustInfo is giving me crap. My goal of this database is to enter customer returns, from one form i want the customer info to go to the corrrect table, same as orderinfo, and partinfo, and transinfo. The little bit of return info will go to that table also. Is this possible from one form? would it be easier to put this on the intranet and build a form online to do this for me? Please help!!

 

[Nowell]

Hi,

I couldn't see your tables no image attached, but i did see your relationships, did you create the relationships as look up tables? I think you need to create proper one to many relationships, I have had problems with look up tables before.