Best way to link a master table to 16 tables

P

PRAV

hi, i'm having a big problem. Before i have a Project table that is
linked to the Milestones table. The relationship was one to many. As
there is a limitation on the number of columns in one table i can't add
columns in the Milestones table which i need to.
Therefore i thought of creating 10 tables for 10 milestones.How ever, i
getting an error "This recordset is not updatable" when i trying to
update the data on my MS Access 97 form. Is this a good option to 1
table link to 16 tables .Another question, when creating a new project
how can i make my 10 milestones reference to that project i just
created.Thanks
 
G

Guest

You don't need to add more columns - you need to add
milestone records to a milestone table. The limit on the
number of records you can easily add is in the millions.

(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a master table to 16 tables, good or bad??? 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Update syntax for a remote table access 1
Updating a Linked Table 4
Link Access 2000 DB to SQL Server 2000 DB 1
Best way to deal with record-locking conflicts 2
Linking Access 2007 to Microsoft Project 2007 5
Data not showing up in Subform 4

Top