Database Design

[bdonelson]

Hi Everyone,

I have a simple database in MSAccess that I need to produce in Filemaker. The problem is that the fm database does not allow me to filter records from one table, based on the selection in another.

I have included a version in Access & Filemaker.

I am probably missing something simple. I would appreciate some help.

Thanks,

Locks.zip

[aaa]

Hi, bdonelson!

You can create relationship from one table to other, you can find records in the table based on the information from other.

Please post detailes for what you want to find from which table in your attachment.

[bdonelson]

Actually I have done this. When I perform a find on one table, the related table still displays all records.

Thanks,