|
I have 2 tables in MS Access
Username is set as the primary key that relates both the tables
I want to insert fields into my second table from my form along with the Username from the first table
how can i do this?
can anybody help me on this?
thanks in advance
|
|
|
|
|
can u be more specific regarding ur need ?
=> U want to insert record in master table and then in detail table ? OR
=> U already have record in master table and insert in detail table ?
|
|
|
|
|
i need to insert in the detail table
master table and detail table has Username field unique
from the logon screen, username has to be fetched and stored in the detailed table and from another form few fields has to be inserted in the same table
in simple, i want to insert fields from two screens into a single(detailed) table
modified on Tuesday, February 3, 2009 8:16 AM
|
|
|
|
|
A Username is a very bad field to use as a key. Use an auto-incrementing number instead.
There are, literally, thousands of examples of how to do this on the web. All you have to do is search[^].
|
|
|
|
|
Dave Kreskowiak wrote: Use an auto-incrementing number instead.
Isn't that considered bad practice?
Can't recall any examples right now but I seem to remember that you could have a number of difficulty's with those.
|
|
|
|
|
Using an auto-increment isn't nearly as bad as using a string and duplicating that time and time again. At least, with a 32-bit integer, you've got a couple billion records to work with and it's a guaranteed 4-bytes per record. How long would that string be??
|
|
|
|
|
I agree that its (a lot) better than using a string, I just thought it was considered bad practice to use a auto-increment.
But I guess in his case it couldn't do much harm.
|
|
|
|
|
Why would you consider using auto-increment keys as a bad practice 
|
|
|
|
|
well as I said in my first post I don't recall the exact problem with it but do remember have some problems with it, and I try to avoid using them as much as I can now.
|
|
|
|
|
One problem is that if you use auto increment keys only, you may have logically duplicate data. But on the upside, updating the user defined data is a whole lot easier and faster (no cascaded updates etc.).
These are the reasons I always use (at least) double keys on every table and I haven't experienced any problems. However, if you remember the scenario at some point, I would be very happy to hear it 
|
|
|
|
|
somebody help me to solve this problem
|
|
|
|
|
Dave answered your question.
You'll need to "remember" (store in variable) the username from the first form and then when user entered data one the second you'll have to use a INSERT or UPDATE sql statement (depending on whether or not it is a new user or existing).
If you search the web you'll find thousands of examples.
|
|
|
|
|
I have two tables
first one contains username and password as fields and the second table contains username,date,project and hours field
the user has to logon from the first form with username and password which leads to a second form where date,project nd hours are entered
when the submit button is clicked on this form, username,date,project and hours has to be entered into the second table
from the logon form, username has to be fetched and stored in the second table and from the current form few fields has to be inserted in the same table when submit is clicked
|
|
|
|
|
Repeating your question isn't going to change the answer.
Like I said you'll have to store the username in a variable that can be accessed by the second form.
Then in the submit click event you'll have to use a INSERT sql statement to insert the correct data into the second table (provided that the username is present in the first table)
On a side note you might want to take Dave's advice and change your key to a numeric key (auto increment).
Don't expect us to write this for you.
This is very basic and we are happy to help where needed but you need to program it. If you get stuck on a particular part you can then come back here and ask a more specific question, because the way your asking it now is asking us to write your whole program. If you want that go to rentacoder.com.
|
|
|
|
|
i have done my coding part
the datas from my second form is stored well in the table
i have used a variable as u said and have used that variable in my insert query but the data is not been retrieved
anyways thanks for replying and helping
|
|
|
|
|
Well that's different then.
Do you get an error? If so post it here.
What do you mean with
vijay2482 wrote: the data is not been retrieved
Are you trying to retrieve the data from the DB after you inserted it (if so you'll have to do a SELECT after it ).
Or do you mean that your variable is empty?
If so:
Try passing the username to the second form in the constructor of the second form and setting a local variable on the second form.
Accessing a variable on the first form from the second form will only work if that variable is declared as 'shared' or if you have a reference to the first form on your second, but since you probably close the first form there is no such reference.
|
|
|
|
|
i dont get any error msg
im trying to store a value from the first for in the database
|
|
|
|
|
vijay2482 wrote: im trying to store a value from the first for in the database
When? Upon clicking the submit?
If so:
You need to pass the variable to the second form when you open the second form:
dim frm as form2(variable)
Then in the second form:
private sUsername as string
public sub new(variable as string)
initializecomponent
susername = variable
end sub
Now you can use that variable (susername) in the submit button
Without more explanation(and perhaps a bit off your code) I can't give more info than that.
|
|
|
|
|
iam trying it out will get to you back if i find some problem
thanks
|
|
|
|
|
i have sorted out the problem
thanks a lot
modified on Wednesday, February 4, 2009 6:10 AM
|
|
|
|
|
Dear use Update Query inplace of Insert
As i understand if UserName feild is primary key so in whole table we will found only one entry for that userName so use Update Query with WHERE Condition
Update tblName Set f1 = v1 ,f2= v2... WHERE UserName = "UserName"
|
|
|
|
|
Please Tell me about the Full Text Query!
Why and How we use the Full Text Query....
as soon as possible........
Thanx!!!!!!!!!!!!!!!!
|
|
|
|
|
Class starts at 8.30. Make sure you're on time and bring pen and paper to make notes 
I are troll
|
|
|
|
|
All you had to do to find this out is use any search engine. Here, let me show you[^].
|
|
|
|
|
He can't google he is doing his exam and the teachers blocked it but forgot to block CP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
