I am working in that database. I am trying to add two new columns in that
table. The table is called Main1. I want to add two new columns/fields
(First Name and Last Name) but it keeps telling me that Main1 has other
tables linked to it so I cannot create the two new fields.
The trouble is that the word 'link' has two different meanings: tables
can be Linked, that is they reside in a separate database (a
"backend") and your frontend database doesn't actually contain the
tables, only a pointer to them (a 'link'). This will be visible in the
Database window by showing each such linked table with a bold black
arrow to the left of the table name. If you don't have such arrows,
the database splitter has not been run, and this isn't the source of
the problem! From your initial message it sounded like it was, but the
paragraph above suggests otherwise.
The other kind of 'link' is a Relationship between two tables.
Normally adding a new field to a table should not be affected by such
a Relationship; but you may need to open the Relationships window, and
select the line from the table you're trying to edit to whatever other
table it's related to. Delete the join line (not the table icon). Then
edit the new fields into the table, go back into the relationships
window, and create the join again.