Pre enter data i tables... 1

[Fensbo]

Is it possible to pre enter data into tables when for instance a new customer is entered then the fields Accounts.Order becomes 0 and Accounts.Price becomes 0 ON Customer.ID=Accounts.ID on the fly?!

Customer
ID
Name
Adress
...
Accounts
ID
Order
Price

Hmm...?!

 

[Remou]

Hi
Does Default Value not suit your purposes? It can be set for table and form fields.

 

[Fensbo]

Hi,

I want the DB to create a row in Accounts and insert values that I define, when a customer is added to Customer...

)

/Christian

 

[lespaul]

Ok, in the table setup grid for each field you can specify a default value (which is the one that is filled in when a new record is created). Again, does that not suit your purposes?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[Fensbo]

Okay, how do I get it to create a row by it self in table:Accounts whenever a row is created, by a user, in table:Customer (with default values) ?!

 

[lespaul]

you would have to write some code within the form that creates the Customer record to insert the record in the accounts table.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual