I need to have the No's and colors coloums from my first table... here the No's columns is set as a primary key.... I need my new table with first 3 columns of the first table as it is and my fourth column of the new table should be from my second table, with only those fields that are present from the No's and colors column of the first table...
for example...
my first table has No's 1 and color...
shreeks
Last Activity: Feb 17 '09, 04:36 PM
Joined: Jan 26 '09
Location:
-
Help with queries
Hi,
I am very much new working on Access database. I have 2 tables,
My first table is like
No's colors made
1 blue nissan
2 red corolla
My second table is like
No's colors car
1 blue sentra
1 red altima
1 green maxima
2 blue corolla
2 ... -
yes my first form is also bound to a record set. yes it is not updating my table..Leave a comment:
-
I didnt write any code there... I just dragged one form into another in design view .... one of my forms has just letter name in it and other form has letter name, letter type and letter description in it.. i dragged the second form and placed it in the first form... so when i type in a letter name in my first form.. the corrosponding record values are being displayed in the subform.....
so I haven't written any code there...
Could...Leave a comment:
-
Acutully here I am not entering the new data ... i am trying to edit the data which is popped up from the table in the subform.
I am not being allowed to edit any data there... I am getting the message as soon as I am trying to click my mouse anywhere on the subform.Leave a comment:
-
Acutually I have setup "Primary Key" on Letter Name field. So it is popping out a message like... " the changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again"
but I dont want duplicates in...Leave a comment:
-
I Created another form say 2nd form with Letter name, and made my original form with letter type, letter category and letter name as the subform. Acutually my Letter name field is set as primary key. Now i entered few values in the table and I am able to retrive the values of the table using my 2nd form by entering the letter name already existing in my table and I am able to see all the values in the subform.
let us say my table has...Leave a comment:
-
Retrival of records from a table
Hi I am new using Access database. I have created a table with several fields like (letter categrory, letter type, letter name etc) in access, using forms and inserted few records in my table. now I wanted to know like if i type in an existing letter name(already placed in a record) in the text field provided for letter name in my form, I need to retrive all other fields of that particular record.
say for example, my record has... -
Retrieval of records
Hi I am new using Access database. I have created a table with several fields like (letter categrory, letter type, letter name etc) in access, using forms and inserted few records in my table. now I wanted to know like if i type in an existing letter name(already placed in a record) in the text field provided for letter name in my form, I need to retrive all other fields of that particular record.
say for example, my record has... -
Link two Fields
I am newbie working on Access.
I am asked to create a new database screen with "Letter Variables" as the field name.
Letter variables is a radio button with Yes and No fields.
If an Yes radio button is selected, additional fileds
variable name ( a text box),
Variable type ( a text box) ,
variable field name( a text box),
Variable Format ( a text box),
must be visible and the user...
No activity results to display
Leave a comment: