Form Advice 1

[dvannoy]

This is a good one...

I have a simple form which users login samples..we receive manifest's that have hazardous waste on each line item..we then take a sample of each line item and run test for them..

The problem Im having is, there could be many different manifest's (all similar waste) that they will put into one sample.

Now on my form I have a field that gives them a sample number. It is working fine. But again they may put up to 50 different manigfest's into one sample..but still have to login each manifest to keep track of it. I created a check box that would let them use the same sample # over and over again for each different manifest.The problem is that when they uncheck the check box for the last manifest that gets logged in they get an error stating that another user has modified the current record since they last did...it will let them save the record but im trying to get rid of that message...

maybe theres a better way to do this...

can anyone help?

Thanks in advance
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JerryDennison]

What you have is a one-many relationship between the sample and manifests. You should have a separate table for each manifest linked to the sample. Then use a mainform/subform to enter the sample information(in the mainform) and each manifest's info information(in the subform).

 

[dvannoy]

Yes that is correct. right now I do have two seperate tables..I have the form based off a query with the manifest linked..so what your saying is to, enter the data directly into each table with out the form being based on a query??? Im not to good with subforms..I never really had to use them before. DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[dvannoy]

Never mind...was easier then I thought..Thanks for your help

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JerryDennison]

You're welcome. I'd written you some detailed instructions but evidently it didn't post properly. I'm glad you got is resolved.