recepbala

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 company

thank you

data entered from front end and back end and no difference ??

table designer
https://prnt.sc/05yJQ-hwYwfP

mysql
https://prnt.sc/DZhk1A_ilJgP

SQL / create table script
CREATE TABLE customers
(customer_id int(11) NOT NULL auto_increment
,recorddate datetime NULL DEFAULT CURRENT_TIMESTAMP
,lastupdate datetime NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
,customer_name varchar(50) NOT NULL
,customer_middlename varchar(50) NULL
,customer_lastname varchar(50) NOT NULL
,customer_country varchar(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 / MyISAM

name, 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/heuWAqSMn1R8

table designer
https://prnt.sc/05yJQ-hwYwfP

• This reply was modified 2 years ago by recepbala.