New Table to Existing Database..

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?

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
*




HeatherEv wrote:
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?