Relations

[Erwin Bormans]

Hi all

I Have a table Customers. But this table is made by other software the
company uses and I want to import this list.

Now I'm looking for the code to delete the relation between my customers
table and the table deliveries.

Then I can delete all the customers, import them form an excel file and
create the relation again.

Its not possible to delete customers in the other software.

Is there a way to do this, or is there maybe a better way?

Kind regards
Erwin

 

[Jerry Whittle]

I wouldn not delete the relationships. Instead I would import from the Excel
file OR link to the Excel file if the name stays the same. Then do an append
query to add new customers. After that do an update query to make any changes
like a new customer address.

One very big question is what is the primary key field in the Customers
table and does the Excel spreadsheet contain this information. For example if
the primary key is the customer name field and the customer changes that
name, there will be problems. If the PK is something such as a number with no
meaning, like an autonumber, things will be much easier.