Add random data on a form's input field

[pdtit]

Hello all,

I'm developing an invoice form, where you have to enter the productnrs (which is bound to tbl_products) as only field to compose the invoice.

This always worked fine, as all products have a number.

Now, I'd like to add "free text lines" for which I don't have article numbers. It should be possible to add a price and VAT as well, just like in the other lines.

eg.
productnr description price vat
123 product nr 123 1€ 0.21
456 product nr 456 6€ 1.26
free text line article custom custom

How could I create this ?

Regards,

Peter

 

[TheAceMan1]

How are ya pdtit . . . . .

There's a possibility if [blue]productnr[/blue] is not a PrimaryKey. You'd have a secondary problem of maintaining record position.

[blue]In any event . . . it would no longer be a [purple]Relational DataBase[/purple] . . . now would it?[/blue]

See Ya! . . . . . .