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

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..

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

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