hi every1, heres my problem...
im creating a simple DataBase, to begin with there is a Parcel table and a Shipment Table. the key fields are Shimpent Id, and Parcel ID, which are both autonumbers.
in the Parcel Table there is also a ShipmentID field. there will be a One to many relationship (one Shipment, has many parcels) between the Shipment ID in the shipment Table, and the shipmentID in the parcel table.
this works, i have 3 shipments,with data such as date, time included, and i beign to fill in hte Parcel table thru the Shipment table by pressing the + sign. i fill in one Record, then i get this error.....
This Expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain to many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
i have absolutely no Idea why this error is occuring, can some1 please help!!!!!
im creating a simple DataBase, to begin with there is a Parcel table and a Shipment Table. the key fields are Shimpent Id, and Parcel ID, which are both autonumbers.
in the Parcel Table there is also a ShipmentID field. there will be a One to many relationship (one Shipment, has many parcels) between the Shipment ID in the shipment Table, and the shipmentID in the parcel table.
this works, i have 3 shipments,with data such as date, time included, and i beign to fill in hte Parcel table thru the Shipment table by pressing the + sign. i fill in one Record, then i get this error.....
This Expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain to many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
i have absolutely no Idea why this error is occuring, can some1 please help!!!!!
