Multiple repairs for 1 item
Hay guys me again,
I’ve come un-stuck once again, I’m now at the repair stage and I’ve got orders deliveries and new items perfect. But now I need to have a system to take an item from a client in for a repair, but this can happen multiple times. The way I’ve currently got it set is on button press it stamps the item with the current repair number, but this doesn’t work as if an item and a 2nd repair it changed the repairID.
Image below shows my current relationships, I know there is a better way of doing it than I currently am, but I can’t figure it out. I’ve only started playing with FM a few weeks ago, so I’m grateful for any help!
add this field to repairs: _fkItemID
Link repairs to items in this relationship:
Repairs::_fkItemId = Item 2::_pkItemID
Then you can have as many repair records as you need for the same record in Item.