Create tabel with relation

T

totto

Hi,
I would like to add a new tabel to an existing Access 97 database that
contains data. This should be done from a .net application via sql script.
The script should aslo add a field to one of the exitsting tabels, with a
relation to a field in the new tabel.

NewTable
NewTableID int PrimaryKey,
NewTableName string;

ExistingTable
--Existing fields--,
NewField int;

I want a one to many relation between NewTableID and NewField.

Anyone who can help me with this ?

Best regards
Totto
 

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

Create table with relations 2
Adding field to existing Table via code 1
Edit text value in two tables 1
Edit text value in two tables 0
programmiclly adding records hits db size limit 16
One-To-Relationship 4
Can't add columns to report's SQL statement 23
Attachment Notification Icon - Create Custom Field to view Attachmentname? 2

Top