[mabbitt]

hello folks,

newb here..

 

i'm currently learning GC

and want to try something like this..

 

 

the tables

   

 

 

 

 

wanted output..

 

Destination : [a dropdown of city list]

Shipping Line : [a dropdown of line list]

Price : [normal input text]

 

 

i'll appreciate if there someone willing to help this newb.. :D

thanks in advance

 

 

[davidoster]

Hello and welcome to the forums.

Try this and let us know if it is what you need.

$crud = new grocery_CRUD();
$crud->set_table('tariff');
$crud->set_relation('city_code', 'city', 'city_name');
$crud->set_relation('line_id', 'line', 'line_type');

[mabbitt]

wow, it works.

thanks a lot...

[mabbitt]

hello again, peeps.

still learning about set_relation,

and feel a bit confused

 

here's the schema

 

 

 

 

 

 

 

 

 

wanted output:

 

trans code:

Destination : [a dropdown of city list]

Shipping Line : [a dropdown of line list]

 

weight:normal text input 

total: generated from multiplying price in tariff by weight in trans

status:a dropdown of status list

trans_date

 

thanks again