Hi,

I'm a real newbie to databases, but am a computer veteran of some 22 years.

I'm using Filemaker Pro to create a really simple customer tracking database, where I just log their details into a single page.

Now I want to add some extra functionality: I need to make a kind of sub database that can be attached to the main customer record where I can make lists of what each customer brings in to me to be repaired. I initially didn't think I'd get that much repeat work with what I do, but it's growing and my database is inadequate. Ideally I click a button and it takes me into a sub menu or database with all that customers repaired items.

Any suggestions on how I can make a sub or linked database that has each customers visit and item repaired, attached to their main 'name card'.

Go easy on the DB jargon, as mentioned I'm new to all this!!

Thanks in Advance.

Ken - London UK.

The simplest is a portal with "allow creation of related records." Works fine with a limited number of repeat word per customer.

Notice the relationship is on the CustomerID, which the portal causes to be automatically entered as soon as you enter anything.

Look at the Relationship Graph.

You would probably also want a list view and a report layout in both Customers and Repairs. But the attached is the basics.

CustomerRepairs.zip