Field cannot be modified until given a valid value

[TaiChi56]

I hope I am submitting this in the right place. Also I thought I already did this but cannot find it anywhere. I looked in my profile console and did not see any messages. So maybe I did not submit it like I thought. I have a database that is not letting me put anything in the field. I am getting this error:

 

"This field cannot be modified until "Room" is given a valid value."

I read up on it and it says something about a matching field. Cannot figure it out. I attached a sample database so you can see what is going on. Thank you.

Inventory_ForumUpload.zip

[eos]

Trying to modify a field in the portal will cause FileMaker to try to create the portal row; since the portal row is actually a related record, this is not possible if the match field for the relationship (Room) is empty, because then FileMaker doesn't know what value to put into the foreign key in the other table.

 

Make sure the record has a roomID before trying to enter data into the portal; as with all fields that are used as primary keys, you should set an auto-enter option. I also recommend employing a naming convention that helps you to tell what a field is doing; "Room" sounds like a room name, not a primary key.

 

“Read up” some more on the way relationships work, and what primary and foreign keys are … because understanding these topics is critical to get a database system up and running. 

[TaiChi56]

Alright I read up on foreign keys and relationships and have been working on this since last post. I am just not getting what I need. If a do a layout and pick "Show records from Location" and then drag fields onto the layout from Inventory it will not let me input anything in the inventory layout. I tried using a join table but was not able to figure it out. Really fraustrating, I know that I should understand realtionships and thought I did. Apparently I don't. I still working on it. Can someone point me in the right direction? Thank you.

Inventory_ForumUpload121213.zip

[eos]

Here is modified version of your database. You tried to create records in the Rooms table, but what you want is to create records in the join table, so your portal needs to point at that table.

 

I added a layout for inventory to create some sample records for the join records; try to add a portal into the join table on that layout, too, so you can see which rooms an item is assigned, and to be able to add items to rooms (instead of vice versa). You could also use a value list for rooms to facilitate data entry, which would be constructed the same way as the Items value list.

ForumUpload121213_MOD.fmp12.zip

[TaiChi56]

Thank you. Now I understand the concept of the join table, i believe. But I am not really there yet on what I need. The user has to be able to input an item for a room. There are multiple items in the room. So room 116 will be in the database up to a possible thirty-five times because of all the computers and technology stuff. So is there a way that a portal can just show room 116 and all of the items in it when searching or when a person is inputting information for room 116 the portal will show everything that is in it at that time. I really apprecaite the help. Trying to get this inventory done so it will save manhours. Thank you.

[bruceR]

I would think it should look something more like this.

ForumUpload121213_MODBFR.fmp12.zip

[TaiChi56]

Everyone has been a great help. I think it is getting closer to what I need. I tried working with it but still not quite there yet. On the locations layout I added the Staff, Item, AssetNumber and ServiceNumber field. Which obviously I do not have it right yet because it will not let me put anything in the field. So here is what happens.

 

- I need the clerk to be able to input all information in the first six fields.

- Then hopefully it will show up in the Inventory Assigned this room as fields:

       - Room, Item, AssetNumeber and ServiceNumber

- I do not need the first value list Inventory_d, I don't think. I made the Staff, Rooms and Item value list.

 

So what I envison is that room 101 will show all the inventory that is in the room. I hope that makes since.

 

Please I really do appreciate the time and effort everyone is putting into this. I think if I can get this done I can study it and it will help me with other databases as I go. Again thank you very much.

ForumUpload_Friday_121313.zip