# Relationship Graph Help **URL:** \ **Category:** Questions\ **Tags:** relationship-graph\ **Created:** [April 11, 2022, 6:53pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852 "2022-04-11T18:53:48Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 6:53pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/1 "2022-04-11T18:53:48Z")
I have a Database with people who are checking out Assets. (Phones, Laptops Etc) I want to have one person be able to check out multiple Assets. How can I achieve this? 1 person, multiple assets This is what I have so far. ![Screen Shot 2022-04-11 at 1.52.41 PM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/0/079caa34240d916f0ad208957c4f79200d6f8284.png) Uploading: Screen Shot 2022-04-11 at 1.52.26 PM.png... ---
**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\ **Post date:** [April 11, 2022, 7:01pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/2 "2022-04-11T19:01:25Z")
That looks correct. `PERSON (one) ---< ASSET_ASSIGNMENT_HISTORY (many)` If you were to put a portal of ASSET\_ASSIGNMENT\_HISTORY on the PERSON layout, you could create multiple assignments. _EDIT: one bit that's confusing me is why the line from person to ASSIGNMENT doesn't have any crows feet on the ASSIGNMENT side_ ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 7:05pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/3 "2022-04-11T19:05:52Z")
_EDIT: one bit that's confusing me is why the line from person to ASSIGNMENT doesn't have any crows feet on the ASSIGNMENT side_ I am not sure what you mean ---
**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\ **Post date:** [April 11, 2022, 7:23pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/4 "2022-04-11T19:23:09Z")
![Screen Shot 2022-04-11 at 12.20.59 PM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/8/839f5f262e4989cd11bcfd3f05e718ad30dd9904.png) I would expect Person\_FK to have the little three prong line like Asset\_FK does. Maybe double check the field definition for Person\_FK to make sure it's correct. ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 7:28pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/5 "2022-04-11T19:28:09Z")
![Screen Shot 2022-04-11 at 2.27.01 PM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/c/c110c1970731aee27f781a16a574942524cc8388.png) I used Filemaker's default way of creating the ID fields, The fk And PK both are like this, is this the problem? ---
**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Post date:** [April 11, 2022, 7:30pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/6 "2022-04-11T19:30:47Z")
Yes. The problem is that you are auto-generating data on the FK side. That data should be pushed in from the PK side. Remove the auto-enter calc on the FK field. ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 7:33pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/7 "2022-04-11T19:33:29Z")
All FK's are this way always correct? ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 7:41pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/8 "2022-04-11T19:41:08Z")
Now I am in person layout, with a person assignment history portal but filemaker is not allowing me to input the asset PK into the ASSET FK field on portal. And when i go to Related Record I am getting the same wrong result... no matter what record I am on. ---
**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\ **Post date:** [April 11, 2022, 7:53pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/9 "2022-04-11T19:53:42Z")
Ah yep, that's the issue Should be something like this [AssetPerson.fmp12](https://the.fmsoup.org/uploads/short-url/nxhsqq5iB8WjVAP8xYxdruacHV7.fmp12) (296 KB) FK fields don't need auto-enters. ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 7:58pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/10 "2022-04-11T19:58:51Z")
Thank you @jwilling ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 8:26pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/11 "2022-04-11T20:26:05Z")
![Screen Shot 2022-04-11 at 3.23.58 PM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/7/7f169d081b083138cc3884b2935ad50f9dd41c52.jpeg) I created this layout do I have to start over to get People in there ? ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 11, 2022, 8:28pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/12 "2022-04-11T20:28:09Z")
I will start over thank you ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [April 11, 2022, 9:01pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/13 "2022-04-11T21:01:16Z")
I would also recommend (when you get things set up again) to do some simple SQL queries - to help make sure both your 1:M (M:M in total) relationships are working. ---
**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Post date:** [April 11, 2022, 11:18pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/16 "2022-04-11T23:18:44Z")
Excellent suggestion. If SQL is in your skill set it is quick and easy to do. If you don't speak SQL, you can drop portals onto the layout, one for each of the related tables and verify the result. That's also quick and easy to do. ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 12, 2022, 12:35am UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/17 "2022-04-12T00:35:07Z")
Any good videos for this ? ---
**Author:** ![pfro](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/pfro/32/1815_2.png) [@pfro](https://the.fmsoup.org/u/pfro)\ **Post date:** [April 13, 2022, 3:31pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/18 "2022-04-13T15:31:25Z")
What you want, it seems.. that multiple Persons can check multiple Assets. Therefore you connected a Joint Table Asset\_History.. That is correct. Asset Attachment.. hmm.. very sophisticated to have that in a vertical table.. but modern.. Verticalize the data.. A mere containerfield with repetitions could also be used Service History. Ok.. A Asset can receive multiple "services" . but a service is always only done on one asset. Looks all good.. that the crow feet do not display.. that is just a filmmaker bug.. or idionsincrasity. ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 13, 2022, 9:08pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/19 "2022-04-13T21:08:35Z")
Now I am trying to add records to Assignment History So I want a list of people who have checked out one phone. Example would be iPhone 11 Serial Number: 123 Has been checked out by Drew on 02/20/2020 Lisa checked out the iphone 04/05/2022 ---
**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\ **Post date:** [April 13, 2022, 9:12pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/20 "2022-04-13T21:12:02Z")
Your join table `ASSET_ASSIGNMENT_HISTORY` can contain `dateCheckedOut` and `dateCheckedIn` fields to describe that. You can also use the absence of a `dateCheckedIn` to determine if the item is available. ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 13, 2022, 9:14pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/21 "2022-04-13T21:14:06Z")
Right, good idea.... If i want related data say the name of the person who checked out the Asset How can I achieve that? ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [April 13, 2022, 9:51pm UTC](https://the.fmsoup.org/t/relationship-graph-help/2852/22 "2022-04-13T21:51:06Z")
Have I been thinking about this wrong? It should be ONE ASSET has ONE ASSIGNEMENT HISTORY WITH MANY PERSONS? so one history service record for every asset with many persons on that history [Next page](https://the.fmsoup.org/t/relationship-graph-help/2852.md?page=2)