New Table to Existing Database..

[HeatherEv]

I am working with a linked FoxPro database. This database is accessed and
updated through another program. I am creating additional functions for
route planning and need to add new tables (because I cannot append the
existing table structure). For example- The database stores customer number
(my primary key) in a field called CNO. In my new table, I am looking to
include call information that will be entered from a form that accesses
several related tables. I need these fields to be associated with the
customer that the notes relate to. How should this be done?

 

[strive4peace]

Hi Heather,

it seems that you can add the CNO field to your Notes table -- probably
Notes would be a subform for the customers table -- then you can use CNO
for the LinkMasterFields and LinkChildFields of the subform control and
Access will fill it out automatically

" I am looking to include call information that will be entered from a
form that accesses several related tables."

can you give an example?


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*