Portal

[msaier]

I have 2 tables that have a relationship. It is essentially goods(inventory) and buyer (cashier). Is there a way to have the portal in cashier only show the items (invoices) not paid. I am sure its easier than i making it, but for the life of me i cant get my head around it.

[dreamingmind]

In your cashier file you can have a global that is set to paid (or not paid) and use this to help link to and filter the invoice items of interest.

Regards,

Don Drake