Exported Query error

[addy]

Newbie to SharePoint 3.0 and run into a problem.

I created a very simple test database in MS Access 2007; 2 Tables:

Table 1 has the following fields:

ID
Document Number
Sheet Number
Title
OwnerID

Table 2 has:

OwnerID
Owner Name

OK, so I created a query using both tables, linking them on OwnerID with the following fields displayed:

Document Number
Sheet Number
Title
Owner Name

Very, very simple.

However, when I export this query to SharePoint 3.0 and look at the List created, I have 4 Field headings:

Document Number
Sheet Number
Title
Owner Name.

So far so good.

However, Document Number and Sheet Number are populated correctly, but Title is blank and the values which should appear under Title are now appearing under Owner Name.

So I have the Titles displayed under the Owner Name, and no Owner Names displayed anywhere?

Any ideas?

 

[addy]

Don't worry about it - figured it out lol