Simple Question ,

[plehoux]

I'm new to this but I know you guys will know how to fix this .

 

What it the proper way to set up the following.

 

It's an invoice, the problem I have has to do with the Product ID and the associted Description. It's a repeating value. If I enter 111 in both product ID and Description the next invoice works great. If I enter 111 again ( in both product ID and Description ) and enter 222 ( in both product ID and Description )in the second of the repeating lines, the next invoice will record the 222 in the Prod ID but the Desciption for that item will be 111, no mater how many items I enter in an invoice in always records the associted Description of the first one I entered on the first line , I hope you guys understand what I trying say.

 

help please

 

thanks

[andygaunt]

Well, it is the old repeating fields syndrome again.

 

I suspect that is your problem.

 

Have you thought about seperating the lines of the invoice out into a seperate database, related to the main invoice file by the invoices unique id. If you allow creation of related records, then you can have a portal that will let you type in the product lines. This should relieve yourself of this problem

 

Originally posted by plehoux:

[qb]I'm new to this but I know you guys will know how to fix this .

 

What it the proper way to set up the following.

 

It's an invoice, the problem I have has to do with the Product ID and the associted Description. It's a repeating value. If I enter 111 in both product ID and Description the next invoice works great. If I enter 111 again ( in both product ID and Description ) and enter 222 ( in both product ID and Description )in the second of the repeating lines, the next invoice will record the 222 in the Prod ID but the Desciption for that item will be 111, no mater how many items I enter in an invoice in always records the associted Description of the first one I entered on the first line , I hope you guys understand what I trying say.

 

help please

 

thanks[/qb]