Search results

I Think i am understanding how this is suposed to work, please see attached adn comment. I think it is more organized and you are completely right, 1 to 1's were doing nothing. ANy more pointers on the layout? Or anything else?

Here is some more, just in case cant open

ISSkint no i never considered anything as i have little knowledge on available options. I never imagined displaying data from diffirent tables on the same form would be such a problem for me. I always thouhgt it was as simple as choosing the filed from the other table and entring into the form...

Yes i can but form will not work on import, please see attached. Also not sure fi relationships are done properly.

Isskint after a bit of research i figure out a way to 2003 the 2010 DB however fomr did not import so i assume it has the problem with the save as as it was not working. I looked it over and tables seem to be all the same. Please try to open this one. Let me know, thanks.

What happened to my support team :) . Did everyone lose interest already? Is there somethign wrong?

What happened to my support team :) . Did everyone lose interest already? Is there somethign wrong?

Here is update with relationships, any adivse appreciated. Thanks.

This is update with relationships that i think may be right. Any opiniond is appreciated.

THis is update DB file.

This is the updated DB file. Please ignore last one

Pat im starting to get it, makes sense on the cascade. Also thaks for the point on embeddded spaces and characters, i have made most of those changes already, just need to do the special characters now as i missed it during first read. About the golf ball example i need to ask you for...

Isskint i have attached the BD, i feel it would take much less of your time looking at it instead of having me ask you several more questions. I counld not find a duplicate text box but there is a combo box and a filed with same data in them, combo just shows were field has written data from...

I created a new text field and left the default name Text234 or something like that. I used the second versions of DLOOKUP namely =DLookUp("[Case Gross Weight (Kg)]","[Item List]","[ITEMNO]=" & [me].[ItemNo]) and still got the same error. Any ideas?

I get a #Name? showing up in the field. This si what i tried =DLookUp("[Item List]![Case Gross Weight (Kg)]","[Item List]","[Item List]![ITEMNO]=" & [me].[ItemNo]) I also tried this first =DLookUp("[Case Gross Weight (Kg)]","[Item List]","[ITEMNO]=" & [me].[ItemNo]) and get the same...

Isskint i tried the 1 to many from Packaging to Zeea Product SPec DB on the packagin field, it seems to work, i tested and seems okay. I am still a bot worried i did not miss anything. I removed the ID field and the ItemNo field and made the Packaging field the primary field (there will only...

I still need to be a bother and clarify something. The whole i dea of the Packaging table was so that when our packaging changes i can go into the table and change a field that would update automatically all records from the Zeea Product Spec DB. This way i wodl not have to go through every...

Okay great thanks. So i relate ItemNo on the Packaging Table to ItemNo on the Zeea Product Specification Table and i use a 1 to many? what kind of join and is the join from Packaging to Zeea Spec DB or the other way around (the one part). Or does it matter which way? I hate to ask so many...

Isskint thanks for responding to both my posts. Can you please responnd again to me using the proper fields names, sorry i had not provided them in origianl post as i thought i could figure it out but i may have messed up some of the name. Please see below Table1: Item List Fileds ITEMNO DESC...

Thank you for the helpful information Isskint and JL Cantara , i think the DLOOKUP may work better for me as i cannot get used to the look of the subform in the original form and i cant organize the fields our of the subform. I can;t seem to get the DLOOKUP to work , it is probably the syntax, i...