Pick list question
I'm from an Access background (your condolences are appreciated). As briefly as possible: One table is a list of time slots. I view it in table or list view so I can see as many as possible, which ones are open. Another table is people. I have a field that concatentates first, last, title, etc to make a unique name, and I have a person number. I can relate the fields through either. Typically the db operator is working in the detailed view of a person, they should be able to click a button (I've got scripts down pretty well) and have that table/list view of time slots come up, see open ones, select one and the name from the detail form gets put in there. When they close that and are back at the detail view of the person it should show their scheduled time.
I've searched here. The forum search engine doesn't seem very accurate, and maybe "pick list" is just not a terminology or method common in FM. I looked at some templates. The "Events" template for instance has a pull down list to pick contacts to go with an event, but the properties of the field are not as a pull-down, so that's just more confusing. Trying to simply make my own pull-down it doesn't offer to connect it to a field and seems to want a dedicated list to connect it with. I just need the general approach that would flow best with FM's way of doing things. Thanks.