Andrew McDonald

Thank you, that actually gets very close. So I need to read up on portals and related fields, subjects that I have only a tenuous grasp of. That was very helpful. I was just holding the room available data in a number field, not related to specific records which are the room applicants.

Have updated my profile Lee. Consultant post. I don't have a record for each room type, I have a record for each applicant. I also want to see the availabilty for all room types all the time whatever applicant record I am on. Anyway, going back to my piece of paper and crossing them off for now.

it doesn't have to be that complicated, all it is is a straight countdown. The allocations don't refer to a specific room, just a pool of available rooms More like a preallocation. What I've got works perfectly, the script subtracts one from a preset value stored in a specified field and displays that number. There are 9 different room types, and they all countdown correctly. I'm totally happy with that, and just that simple is perfect for this particular database, it's just that it needs to display that data on all the sharers.

OK OW I sort of get that. So maybe a commit step would save the adjusted number and make it consistent across the shared files with my current global field? (Sorry, I'm not an expert. Reason I like FM is that people like me can adjust it easily!)

Thanks mate. have been trying to read the help. I suppose basically I want a field that will show the same data across a number of shared users that's global and not specific to a single record. A standard field, specific to a single record changes immediately for all users. I want that but global. I want to be able to specify a number of room vacancies by manually entering the total vacancies eg 100, and have that number reduce by one every time a room is allocated. I have already got scripts and buttons that do the room allocating, ie I press the button and the record is amended to offered status, emails get sent, paper forms printed etc. I want to be able to also have it reduce number of available rooms by one and have that calculation change on everyone's shared version of the database.

Hi guys.I have a room allocation database. I have made a global number field, and when a room is allocated, it reduces the available number of rooms by one. Very simple and It works fine, but the number does not match for other shared users. I want the number to match for everyone. I thought global would do it. Any suggestions? Thanks