1:n relations

N

Norman Khine

Guest
Hello,
Can someone advise me or point me in the right direction on how to achieve the following.

I only discovered DaDaBIK last night, so please excuse me.

Anyhow, I have two tables, BusinessName and BusinessAddress, as follows:

CREATE TABLE BusinessName (
BusID int(11) NOT NULL auto_increment,
BusinessName varchar(40) default NULL,
Logo blob,
ImageOne blob,
ImageTwo blob,
ImageThree blob,
CompanyInfo text,
NoEmployees int(11) default NULL,
Turnover int(11) default NULL,
URL varchar(35) default NULL,
FK_MainBusID int(11) NOT NULL default '0',
Status int(2) NOT NULL default '0',
PRIMARY KEY (BusID)
) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=150 ;

CREATE TABLE BusinessAddress (
BusAddID int(11) NOT NULL auto_increment,
StreetName varchar(25) default NULL,
Town varchar(25) default NULL,
City varchar(25) default NULL,
State varchar(40) default NULL,
PostCode varchar(10) default NULL,
HomeOrBusiness smallint(6) NOT NULL default '0',
FK_CountyID int(11) NOT NULL default '0',
FK_CountryID int(11) NOT NULL default '222',
FK_BusID int(11) NOT NULL default '0',
FK_PostTownID int(11) default NULL,
PRIMARY KEY (BusAddID)
) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=151 ;

Is there a way that when I update the BusinessAddress record to be able to have the FK_BusID field fixed, I can't see where to set this relation between the two tables.

I can see that there is an entry in the table admin screen to add Foraeign Key for Table, but the BusinessAddress has 4 different FK_ how can I create a form to link to each different table?

Hope it makes sense!

Please advise.

Thanks

Norman
 
E

Eugenio

Guest
Norman Khine wrote:

> Hello,
> Can someone advise me or point me in the right direction on
> how to achieve the following.
>
> I only discovered DaDaBIK last night, so please excuse me.
>
> Anyhow, I have two tables, BusinessName and BusinessAddress,
> as follows:

[....]

> Is there a way that when I update the BusinessAddress record
> to be able to have the FK_BusID field fixed, I can't see where
> to set this relation between the two tables.
>
> I can see that there is an entry in the table admin screen to
> add Foraeign Key for Table, but the BusinessAddress has 4
> different FK_ how can I create a form to link to each different
> table?

Your question is not very clear: if you update the first table I think you don't have to change BusID so you don't have problems about updating the second one.



(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
Top