[AccessD] A little help, please

Susan Harkins ssharkins at gmail.com
Mon Mar 30 11:52:55 CDT 2009



> Perhaps my entire approach is wrong.  Here's what I am trying to do:
> I am trying to create a list of payees from two tables:  1) Faculty/staff 
> info is added by HR personnel to database1.T1; Vendors and external people 
> would be entered into database2.T2.  Only T2 would ever be updated from 
> this source.  And yes...it is a concern that both have autonumber pk's, 
> which I have no idea how to resolve.  FYI...a new record would require 
> more than just the name of the vendor (e.g., phone #, etc).

======What happens when a user selects a list item that's from database1.T1? 
I guess my question is, why do you want to combine these records if only one 
set will actually need updating? Will users really want to just view some 
records and update others?

Susan H. 




More information about the AccessD mailing list