how ot create a realtionship table.step by step?
537043
You take the primary key from the two tables that you are trying to relate, and copy them into your relationship table.
401213
You'll need to create a database using MySQL, Microsoft SQL or something similar, and pick one of the computers to be the main repository or master. You fill the database up with the current information then copy it to a second database in the other computer, using a second copy of the same software. You then set the two databases to "talk" to each other; during the "conversation" they have, they will update each other with the changes made, no matter where they have been changed. \n\nI'm not sure if you can do this with Microsoft Access but to get it to work right, you'll need a database administrator to make the initial setup and show you how to make the two Quickbooks talk to each other. It is a pretty common task so any decent database admin should be able to get it up and running in less than a day unless your Quickbooks has something quirky about it, or unless you have a lot of data to translate over.\n\nIt's hard to find a reasonably priced freelancer for such a short job because freelancers and consultants usually want a couple weeks' worth of work before taking a project. I'd recommend talking to some friends to see if any of them know a good IT guy in their office (sounds like your office is pretty small). If you can find the tech to do it, I can tell you exactly what to ask for in Microsoft talk. \n\nAlternately, you can consider converting the QuickBooks into an online database program which would be accessible from anywhere that you have an Internet connection, and it would be real-time; if your secretary updated something, you'd see it in an instant. I'm not sure what features you need so I can't recommend one but go to your choice of search engine, and search for "online database" then go browsing!
860449
Make a table with two columns.
431188
when u create table in design view,and select field. there is look up option ear general TAB.click on that tab if u have text field then u r able to change it and make combo. then u have to give reference combo to perticular table field by using query
1095851
I certainly would not use multiple table for something that simple. It is like going around the world to get back to your elbow.\n\nFurthermore, I think that it is a one to many relationship...one applicant to many jobs or one applicant to many schools.\n\nIt can all be done in a single table and use a long text field as the experience and use a long text field as the education.\n\nYou can use a delimited field broken down between one job and the next or between one school and the next.\n\nDoing a search, you can search for any schools (a string) with in a text field.\n\nThe answer would not just apply to Access, but any database application.
967929
Best way is to have 2 tables.  A header and details table.\n\nThe header table will have one row per sale.  Key field would be invoice number.\n\nThe detail table will have details of each sale.  One row per item.  Key field would be invoice number and item number\n\nJoin field would be invoice number.
611328
I would just use Excel to produce such table.
1013881
Look at other procedures within your office. Surely they follow some sort of template.\n\nI suggest doing that. Look at the other procedures and copy the format.
646148
Get one of those marriage planner books. They have checklists of everything you could imagine.
1012904
I would suggest keep it simple.  You need a plain database ... use Microsoft Access, or even Excel.\n\nIf Excel, you need to be careful while structuring and entering data.  Since Excel is freeform (flexible), some discipline is required for good results.
486418
I'd simply use a table, however if you want to get very detailed, you could use the Word Drawing tools to do this same thing
147102
Create the table you want to make.  Then go to Table and click on Draw Table.  You can physically make the lines yourself in the row you want.
518266
I would start with the Db design. You are going to need a junction table to resolve the many to many relationships you are going to have. \n\nSo if your user table has fields like\n\nUserId\nName\netc..\n\nThen your second table will need sometihng like\n\nFriendID\nUserID1\nUserID2\n\nThen you will be able to resolve the names of the people who know one another and draw your relationship. When you add the link, then a record will need to be inserted to keep track of it for future requests. \n\nYou are going to need a lot more than this, but this should get you a start. I would look at using something like DotNetNuke to take care of some of the plumbing of the application and then just write  a module for DNN then will allow you to accomplish your logic here.
687165
First create the table with the data, then go to the query tab and select the wizard query, it will walk you through the steps to creat one. \nOnce you have your query set up, you can sort and filter as you wish.
1132417
Skip calling the stored proc and use a cursor to grab the rows directly and insert them into the second table.\n\nExample cursor:\n--------------------------\nDECLARE @col1_value VARCHAR(100)\nDECLARE @col2_value VARCHAR(100)\n\nDECLARE cc CURSOR FOR\nSELECT col1, col2\nFROM table1\n\nOPEN cc\n\nFETCH NEXT FROM cc INTO @col1_value, @col2_value\n\nWHILE @@FETCH_STATUS=0\nBEGIN\n\nINSERT INTO table2 (column1, column2)\nVALUES @col1_value, @col2_value\n\nEND\n\nCLOSE cc\nDEALLOCATE cc\n--------------------------
106090
I would suggest working on the key theme and placing some of your own thoughts on the papers.  If you are using 20 keys, make a list of 20 things that has helped your marriage be a success.  An example:\n\nKey #1 to our success:  An open line of communication\nKey #2 to our marriage success:  A mutual respect for eachother\nKey #3 to our happiness:  Our ability to share the remote control!\n\nThis will allow your guests to have some insight to your lives and will provide reflection for the reason of the gathering.  They will also be curious to know what is on each of the tables so it could encourage your guests to mingle as well.
915895
yah. u should try microsoft front page.....\nthere u can paste ur tables in normal page and can see the html coding in the html page tab......try it