Advice

[Mary Office Manager]

I have my db set up to handle expenses. I have the main table, "Expenses" and a related table, "Expense Items"

The Expenses table is the entire invoice/receipt, where as the Expense Items are each individual line item on the invoice/receipt.

I thought about using the tab feature to separate my expenses. One tab, credit cards, the other tab Invoices, etc.

Question...does that sound like the best set up for what I want?

Any suggestions or advice would greatly appreciated.

Thank you,

Mary

[Fitch]

Depends what you want. You'll need a relationship that in addition to the Expense ID also uses a global field for the expense type. Since the global has to be set to the desired type (invoice, credit card, etc.) you might want to try just making it a drop down value list, with your expense items portal below. Then if that's not enough you can use it to build the whole scripted tab thing later -- which by the way is a bit easier if you upgrade to at least FileMaker 8.5.