Ok, I have a simple 2-layout, single table database that consist of an invoicing layout, and an order entry layout (using FM Pro 8 Advanced)

The way it works is when an order comes in, all the information is entered and a unique order number is generated for that particular job.

The invoice then reflects that order number for each invoice that is generated against that particular job as well as an invoice number.

What I want to do is add a list at the bottom of the order entry page that shows each invoice generated against that order number – usually 1-8 invoices before the job is finally out the door.

My problem is, I can’t figure out how to isolate only the invoices that reflect that the current job number and have that information returned to the list. I need it to include, invoice number, date invoiced, amount invoiced, and then total amount invoiced.

I don’t know if I have given you enough information, but if someone could point me to a solution I would be most grateful.

I would not consider myself and advanced user (obviously), so assume that you are trying to communicate with a rookie here.

Any help would be greatly appreciated.

Thanks,

Brad

You need to relate your order table to your invoice table by matching the order number in each. Then a portal in the order entry table pointing to the invoice table will do the task that you want. You choose which fields go into the portal in layout mode when you place a portal on the layout. If your list is likely to exceed the space available make sure that you have a vertical scroll bar selected in the portal options.

SlimJim,

Thanks for the reply!!

I think my problem may be that the entire DB only uses one table.

So I assume based on your response, I should create a second table just for the order entry layout?

Thanks,

Brad

My apologies. I saw 2-layout and failed to notice single table. I would not advise you to keep to one table. You should have an order table and an invoice table. However, if you do want to stick to one table then in the relationship graph make a second copy of your table and relate the two copies by order number this will produce a list in the portal of all invoices and the original order.

I have to say that you are storing up problems if you stick to one table. You really need to have separate Order and Invoice tables at the least.