1 Topic by jestoy.olazo (edited by jestoy.olazo 2014-05-13 18:20:24)

  • Registered: 2014-05-13
  • Posts: 2

Topic: Automatic Assigning of Values

Hi good evening, I am Jessie and I am currently amaze with your application. I am working on my database for a possible replacement of bin card on my work. I am just wondering whether is it possible for an automatic assigning of value to another field base on the combobox value I selected?

1st Table

id_2ndtable    [2ndtable] - relationship
desc           text
uom            text
qty               text

2nd Table

item_code   text
desc             text
uom              text

For instance I will select id_2ndtable on the 1st table via combobox then it will automatically fill in the details for the desc & uom on 1st table based on the 2nd table value of desc & uom? Hope you understand. Thank you. And more power.

jestoy.olazo's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Automatic Assigning of Values

Hello,

Do you mean Linked list  like: Country > Region > City > Street  ?


You can find this sample in:
Documents\My Visual Database\Examples\Linked Lists


You can also see several fields in ComboBox, example:
property FieldName: {item_code} Description: {desc}


where {item_code}  and {desc} is fields from database.

Dmitry.
  • Registered: 2014-05-13
  • Posts: 2

Re: Automatic Assigning of Values

Thank you for the reply.

Based on the sample database: Country > Region > City

should I make:        itemcode > description > uom         in 3 separate tables united
by relationships?

I will try this  and will give you an image of what I have  done.

Thank you again.

jestoy.olazo's Website