Invoice Database... Issue with Creating New Record.

[Thedm]

I am creating an invoice database.

It is a standard invoice solution with one minor glitch.

Each customer CAN have a different price with each product.

To solve this i created a join table between products and customers and put a portal on the customer page where the user can from a drop down change any price manually.
That works fine.

But now when I try to create a new invoice the invoice table doesn't insert the customer name-address etc.

Here is what I have.

I cant see the forest through the trees on this one... can anyone give a hint.

thanks

[Thedm]

I realize one of my main issues is that I have Cutomers-->Products-->>Custom Price then join that with Invoices.. vs Customer-->Invoices join with products... But i dont see another way to do custom prices..

[Lutmers]

Hi Thedm,

 

Your relationship between invoices and customers will not be valid until there is Line_item. 

This is a curious way of doing the relationship.

 

Why not make a new instance of your CUSTOMER table (copy it) and place it right from INVOICES and relate based on _kf_Customer >_kp_Customer.

Your set.. the price relation will do it's own thing.

 

Good luck

Jeroen

[TKnTexas]

Does each customer have product specific prices for them?  Or do they get an across the board discount off standard pricing?