Header & Items Mismatch

[[email protected]]

Hello,

I'm running into instances of where I can have an Invoice Header with no Invoice items attaced to it. Normally, this happens when I have a brand new user, and there are no records associated to that user. Anyway to avoid "orphan record creation" from the header and line items when this happens ??

Ryland

[Tom Cone Jr]

Re: Header & Items Mismatch

Sounds like you have a parent and no children... not an orphaned child record. In any event the answer to your question is yes, but we'll need to see your app and you'll need to furnish keystroke by mouseclick instructions for us to mimic the data entry sequence your user is following to create the problem.

[Tom Henkel]

Re: Header & Items Mismatch

You could avoid printing blank invoices by filtering with a "scanning" option. Scanning tests to see if there are any child records at a specific level of the set. If none, don't print the invoice.

Tom

[[email protected]]

Re: Header & Items Mismatch

Thanks,

I've attached a sample of the database. The scan login is "rsw123" from the main menu.

From there, go to "Tool Return", and select "Tool Std Return" passord is "123456".

From the drop down, select any of the first 3 inventory item (from the Product) table, and this is where it appears to create the blank records into the Product table.

Thanks again for any insight as to what this occurrs.

[glenschild]

Re: Header & Items Mismatch

In your invoice header table the Invoice_Number field is C:14 whereas in the Invoice items table the Invoice_Number field is set to C:6

Also in the product table field rules for product_id you have the data entry set for "always Required" AND you have a custom validation set as well. I removed the custom validation and it seems to work.

Regards

Glen

[[email protected]]

Re: Header & Items Mismatch

Thanks will give it a try, and let ya'll know. Ryland

[[email protected]]

Re: Header & Items Mismatch

I tried what you suggested, and I'm still getting a blank record that keeps getting written to the Product file....It's weird because you would have thought that the field validation rule would have prevented that, but why I don't get the same behavior on the Invoice entry screen is beyond me... What I do is then go to the Product file and with an assending sort, the blank record appears...

[glenschild]

Re: Header & Items Mismatch

I did notice that there were a couple of blank entries in the product field. Try deleting those and have another go.

[[email protected]]

Re: Header & Items Mismatch

Yes, I just delete those. retied. Noticed that the same think happened.

What I just did however, was to remove a couple of msgbox's in the return and then added an additional button to commit the record at the end. The first run appeared to be ok in not generating the additional blank record in the product field....will continue testing and let everyone what we find out.

Thanks,

Ryland

[[email protected]]

Re: Header & Items Mismatch

Problem solved. I added a forced save - commit at the end of the return record, and removed the display messages that were appearing.

Thanks for everyone's help.

Ryland