Join table or is there a better way?

[sarahw]

Hi, this is probably pretty simple but I would appreciate some direction on how best to approach this. Join table? Some other method?

I have a list of fields that will be used for Budget and Actual costs for each inventory item (these are real estate assets). The fields will be the same, except one occurrence is budget and the other is actual. I will have them on one layout page side by side.

e.g.

BUDGET:

Purchase Price

Fix Up Costs

Closing Costs

Taxes

ACTUAL:

Purchase Price

Fix Up Costs

Closing Costs

Taxes

Any pointers would be appreciated! thank you.

[comment]

If I understand correctly, each asset has exactly ONE budgeted purchase price, ONE actual purchase price, and so on. I'd say these should be eight fields in the Assets table.

However, my reply might be different if you ever need to summarize these separately, for example:

AREA A:

• Total Budget

• Total Actual

AREA B:

• Total Budget

• Total Actual

...

[sarahw]

Thanks, OK so that's pretty simple and should work fine. Just wondered if there was a better/more correct way to do it but simple is good :0