Database Navigation

[DukeS]

Hi!

Maybe this is off topic but here's the deal.

I have problem with navigation in database. I want to create one table for persons and each person should be treated with his set of records like person's income and expenses. I have to be able to select the person I am working on and database should show me just person's records. I want to have everything on one layout. Database would be similar to Home Budgets template from FM but with many person's.

I know how to create database schema and relationships, that is not a problem. Problem for me is how to select a person (or with Login) and then work just with person's records. GoToRelated record works only if you have related record already created (which makes sense I guess ::. Ideal would be that after selecting person, empty database should show up (or with records created before) but only for this person. I guess that you have to work with found sets of records. But then what if person is searching information? Then search would find every record from database. I am little confused here.

Appreciate your help and suggestions

Thanks

Dejan