Searching and automatically updating fields 
Author Message
 Searching and automatically updating fields

I have created a table to schedule meetings.  the table consists of 16
fields. The Company ID's are already filled in and I am scheduling
individuals to meet with each company.
Fields in table:
record count (automatic count)
Company ID
Meeting 1
Meeting 2
Meeting 3
Meeting 4
Meeting 5....through 14

the table looks like:
Count    CoID        Mtg1    Mtg2    Mt3    Mtg4    Mtg5......
1            COA        Dist1
2            COB
3            COC                    Dist1

I have setup theMeeting fields as "no duplicates" to prevent me from
scheduling the same person at the same time for different companies.  This
works fine, but I need to find out is if Access can do the following:

If I try schedule "Distributor 1" to ABC company in the meeting 1 timeslot,
and Distributor 1 has already been scheduled to meet with someone else
within that time slot:
Can Access search on the row that ABC company is on
And Search the other meeting fields
Find a meeting field that Distributor1 has Not been assigned to yet
automatically update the open meeting field for Distributor 1 and company to

Thanks for your help


Sun, 15 Sep 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Automatically Update Field

2. Automatically Update Fields in Word

3. Automatically Update fields

4. Automatically update fields

5. How to have Record_Edit_Date field automatically updated?

6. AddNew/Update command & field searches

7. Tab to search field on search engines

8. Fields, how to search for a specific type of field

9. How to Automatically SEARCH for Servers ?

10. DBCombo box automatically search??????????

11. Using--After Update-- to update field in table.

12. Updating fields: footer doesn't update right


Powered by phpBB® Forum Software