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
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