AnsweredAssumed Answered

How to link/ reference a unique record on one table to another table

Question asked by deedubbauu on Aug 7, 2013
Latest reply on Aug 7, 2013 by deedubbauu

Hi Members,


I'm a filemaker newbie trying to create my first database for my small business. I'm not entirely a novice but I don't mind if you treat me that way!


This database is to record information about stringing jobs. I have four tables in all.

Table 1 - customer information (including a serial/ unique ID record)

Table 2 - raquet information (including a serial/unique ID record)

Table 3 - string job information (including a serial/unique ID record)

Table 4 - relationship table that "shares" data.


I've attached a screen shot below:

Relationship table.png

My layouts are as follows:


Client Info Layout.png Racquet Info Layout.png


String Job Layout.png Client Summary Layout.png


My issues are as follows:


1) I want to add a client name to a racquet. See layout "Racquet Information".

2) I want to do the same thing for String Job Information.


For the Client Summary page I'd like to do the following:


A) Search for a client and find their last racquet strung and populate the relevant fields.


Lastly, is their a way that I can have a time stamp set up inside the comments field to verify each update that I do?


Many thanks for your time and assistance.