How to Update Product filed

[sandya]

Can anyone help on My Products field update issue in form

i have a created Products form with table require

they details are:
Ex:
ID--Brand --- Model -- Color -- - Product
----------------------------------------------------
1---LG Ref -- 123456 ---Red------LG Ref 123456 Red
2---LG WM---123457---White-----LG WM 123457 White
3---TATA-----223652---Silver-----

Above Brand, Model, Color & Product filed details are same.
So above Brand, Model, Color Details are need to update in Product Field with automatically without typing. So any VBA code or any formula will be update automatically??
i have attached the screen shot please replay anyone:banghead:

Advanced Thanks
Sandhya.

 

[plog]

You don't store the Product in a table, you calculate it whenever you need it. And you do that by using concatenation (http://www.techonthenet.com/access/functions/string/concat.php)

 

[Mihail]

Hope that the Product is NOT a field in your table.
If it IS a field in the table, remove it ! Now !

So you have a form based on table tblProducts.
In the detail area you have 4 (four) controls (text boxes) bounded to the table fields.
Usually, the names for this controls are the same as the bounded field.
Create one more UNbound text box. Name it Product.
In the control source type:
= Brand & " " & Model & " " & Color
Save and run the form.

 

[sandya]

But Product field is primary key & relation ship with some tables. Can't remove it

 

[plog]

So why do you have an ID field in the table? What prompted you to include that field in your table?

That is the field which should be used in other tables.

 

[sandya]

i have attached the Relationship Screen shot can you please see once. Then you will be understand.

 

[Mihail]

Yep. I understand that... this is NOT a database.
The MAIN and SINGLE reason that each table should have a field named ID is to use THIS field as primary key (PK) in that table and as foreign key (FK) in a "child" table.

 

[sandya]

Okay got it but i need without remove primary key for product field in table?? Am tried DLookUp with VBA code also but not working. if any suggestion without remove??

 

[sandya]

please can anyone replay for how to do update product field with automatically.:banghead:

 

[jdraw]

Let's start by you describing WHAT your business is. What are the things (entities) involved? These will become tables. How do the tables relate to each other? Tell us some of the business rules that will determine the relationships in the database.

 

[sandya]

Actually these Database is preparing About INVOICE BILLING purpose. I think need to give a primary key for product field in table and also relationship with order details so it is correct? Actually i need only product filed update from Brand, Model, Color fields without typing on form entry. Because Brand, Model, Color Data & Product data is same. If you don't mine can you please see before i have discussed with some guys about product filed update. After then you will understand.

Thanks for replay,
Sandya.

 

[jdraw]

?? Here's a link to a tutorial that will guide you from business definition to a designed database with proper tables and relationships. You'll have to work through it to gain the benefits.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip
Good luck.