linked table question

Hi

I've created a table containing details about boats, I've used this module to build the pages to display boats picked by the various criteria,- so far so good.

As each of the boats can have a separate of the same owner I created another table holding name,address etc .

On each table I added a field called sellerId thinking I could link them as in Alpha5, access etc . I seem unable to locate the way to do this.

Would I do better to do it all on one table and have multiple entries for eacch boat owner?

thanks

Ian

Can you provide some more details on the type of relationship you are trying to create.

is it a many to one relationship?
One owner to many boats?


if this is the case

In the Boats table add a ownerID column. this column will be numeric. in this column add the value from the Primary Key Column of the Owners table to create the relationship of owner to boat.

Hi Jason

yes your surmise is correct. One owner many boats and I 'm using ( well I will use) the Data assist package to create the search and update pages etc.

I tried to do as you said but when I set the field to numeric it accepts but when I save it alters the numeric field to decimal.

I've sql-dddd and ziped up the vast database ( ok two tables)

can you take a look and see what I've done wrong.

thanks

Ian

use int for the column type.

Hi Jason

at the risk of appearing even more stupid how do I

"add the value from the Primary Key Column of the Owners table to create the relationship of owner to boat. "

thanks

Ian

on the page where you are inserting the boat to the database, create a recordset to return the owner name and owner ID

Create a select list that uses the owner recordset. Set the value to use the owner ID column, and the label to use the owner name column

In the insert record behavior, bind the OwnerId column in the boats table to the select list you create.

thanks Jason

Like an idiot I was trying to do it in phpmyadmin! thought it was like a conventional database set

Have a good holiday monday

Ian

you're welcome.