recepbala
Forum Replies Created
-
all start with customer table.
and i got another table showing what is/are serviced to each customers.
parent/child working perfectly.the thing is that this child table got another relations also.
when i add a record, i need service_name from another table related through service_id. i need service_provider_name from another table related through service_provider_id.if it was parent table, i figure things out but it is child table
we may say data project for a small company 🙂
tring to keep track of things going on in the companythank you
data entered from front end and back end and no difference 🙁
table designer
https://prnt.sc/05yJQ-hwYwfPmysql
https://prnt.sc/DZhk1A_ilJgPSQL / create table script
CREATE TABLEcustomers
(customer_idint(11) NOT NULL auto_increment
,recorddatedatetime NULL DEFAULT CURRENT_TIMESTAMP
,lastupdatedatetime NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
,customer_namevarchar(50) NOT NULL
,customer_middlenamevarchar(50) NULL
,customer_lastnamevarchar(50) NOT NULL
,customer_countryvarchar(50) NOT NULL
,PRIMARY KEY (customer_id)
) ENGINE MyISAM DEFAULT CHARACTER SET utf16 COLLATE=utf16_unicode_ci;varchar did work, thanks 🙂
there is one more thing that i could not handle 🙂
recorddate and lastupdate columns got their default values are set at designer.
but when i enter new record, those columns are recorded empty
using mysql / MyISAMname, middle name, surnames are columns as text type. but they appear as multiline text box. they better be single line text box for sure. you can check images.
text fields
https://prnt.sc/heuWAqSMn1R8table designer
https://prnt.sc/05yJQ-hwYwfP- This reply was modified 3 years, 7 months ago by recepbala.