wayne,
this is how it works
1. guest comes to gate gives either resident name or address(lets work on name )
2. guard clicks button on a form or switchboard to enter a partial last name
3. guard chooses from a list of residents hits enter
4. guest list from that loc# (linked from location table) comes up, guard selects guest and hits enter. if guest expire date is expired
a. go to contact form if ok to let in (yes) button to open guest record from guest table and edit dates.
a1. after edit go to frmGlogEnter to enter guest lic.plate and any notes to go into gatelog table
b. if not on guest list go to contact form if ok to let in (yes) button open guest form to enter new guest.
b1. after enter go to frmGlogEnter to enter guest lic.plate and any notes to go into gatelog table
note: guest with no date in the expire field are permanent guests