473,396 Members | 1,779 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

autonumbering?

Whenever I used Approach I could link fields together from the Main
table to the detail table and when I entered the CASE NUMBER in the
Main table it would automatically put that number in the CASE NUMBER
field that it was linked to in the Detail table.

It is a one to many relationship. CASE NUMBER is the linked field.

How can I do that in Access?

I know how to set relationships in Access. What am I not doing
correctly?

Nov 13 '05 #1
1 1297
You need to use a form/subform and set the LinkMaster/Linkchild properties
to Case Number.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Randy" <ra****@msn.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
Whenever I used Approach I could link fields together from the Main
table to the detail table and when I entered the CASE NUMBER in the
Main table it would automatically put that number in the CASE NUMBER
field that it was linked to in the Detail table.

It is a one to many relationship. CASE NUMBER is the linked field.

How can I do that in Access?

I know how to set relationships in Access. What am I not doing
correctly?

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: WangKhar | last post by:
Gents, I have come into a system that uses a secondary table to generate (for want of a better word) Identities. eg create table myidents ( name sysname not null, ident int not null)
2
by: netx | last post by:
I created table with "id" field as "uniqueidentifier" (primary key). I connect via ODBC from MS-Acces. -->>> Don't know how to something like "Autonumber" in MS-Access. Let me know If any...
2
by: Robin Lumley | last post by:
Have set up a inventory of IT equipment in a small school, and I need to give each item a unique serial number, ie: DHRS 01, DHRS 02, etc the text is needed as we intend to security mark, once...
2
by: Richard | last post by:
Hi, Could anyone help me with the following problem? I created a database for scientific documents, using the usual AutoNumbering for creating Document_ID's (primary key). The Document_ID's...
2
by: N. Graves | last post by:
Hey is there a command like in SQL Transactional that will reset the Autonumber field to the highest number in the found in the field? I developing a access database with a several table that...
1
by: BlueHeaven | last post by:
Hi all, How to create auto numbering in datagrid if I show the data from database to datagrid by using datasource = dataset. Thanks all
1
by: Chris | last post by:
I am trying to assign an ID number from one table into another table through forms. Is it possible to create a command button on a form to feed a new record with this existing number? For...
3
by: LeeCaroline | last post by:
Hi, Please forgive me if I use the wrong terminology, I will do the best I can. I am a self-taught Access uses and cueently creating a database for the firm I work for. Part of its function will...
1
by: FRENCH GUY | last post by:
Hi everyone, At the moment, I am working on a database with several tables. Almost every table has her own autonumbering field. So herefore, I am looking for the command that I have to include in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.