Martin, Donna M
dmart06 at emory.edu
Mon Mar 30 12:07:14 CDT 2009
This is an Accounts Payable database that captures and reports on payments made to both faculty, staff, external individuals, as well as vendors like Dell, Microsoft, etc. The HR-side (faculty/staff) is updated and kept current by HR personnel from the other database. T2 can be updated anyway we want. I really do not want the Finance Team people adding any HR data, trust me! So you see my dilemna? thx. Donna -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Monday, March 30, 2009 12:53 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A little help, please > 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments).