I have the task to build a separate table for the payment of the orders containing only the data whether the payment is done or not.Therefore i want to build a table that contains the Yes/No field for the payment of the orders.I have built this table and named it TblPaid.How can i relate it with the table orders so that i could enter the data “paid” in a query containg the orderid from the table orders and the yes/no payment from the table tblPaid?
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Designing a table (Access 2000)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Designing a table (Access 2000)
- This topic has 10 replies, 3 voices, and was last updated 18 years, 3 months ago.
Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody Lounger -
WSsolar
AskWoody LoungerFebruary 18, 2007 at 4:12 am #1052051it is true,i know that.My case is rather special since the table orders is processed from different customers while a separate table will be kept with only one instance.I just want to take your advice and then to proceed.So my question is, can i build a table with another iautonumber d number, for example paidid, the second field to be orders and the third field to be the Yes/No field.In that case i might have a one to many relationsip and it remains to tie up the order id with the relevant Paid field form the table TblPaid.Of course if you tell me that it is impossible i will give up the idea but i strongly hope you might find some way.
-
WSHansV
AskWoody LoungerFebruary 18, 2007 at 10:11 am #1052065You can create a table tblPaid with two fields:
OrderID (number, long integer)
Paid (Yes/No)OrderID must be the primary key of the table, and its Default Value property must be empty (blank, null) instead of 0.
This table does not need an AutoNumber field.Before adding any records to this table, select Tools | Relationships…
Add the Orders table and tblPaid to the window.
Draw a line from OrderID in the Orders table to OrderID in tblPaid to create a relationship.
Tick the first check box in the dialog that appears, to enforce referential integrity. This ensures that you cannot enter a record in tblPaid for an OrderID that does not exist in Orders. -
WSsolar
AskWoody Lounger -
WSpatt
AskWoody Lounger -
WSsolar
AskWoody Lounger -
WSpatt
AskWoody Lounger -
WSHansV
AskWoody LoungerFebruary 18, 2007 at 10:40 pm #1052170You’ll have to add some more fields to the Orders table – a table with only an AutoNumber field is useless.
In the query, double click the line joining the tables.
Select the option to return *all* records from Orders.
You will now see all orders, even if there is no corresponding record in tblPaid. As soon as you click the check box, a record will be created in tblPaid. -
WSsolar
AskWoody Lounger -
WSHansV
AskWoody Lounger
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
3 hours, 18 minutes ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
6 hours ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
34 minutes ago -
Windows Update orchestration platform to update all software
by
Alex5723
13 hours, 19 minutes ago -
May preview updates
by
Susan Bradley
42 minutes ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
2 hours, 53 minutes ago -
Just got this pop-up page while browsing
by
Alex5723
5 hours, 31 minutes ago -
KB5058379 / KB 5061768 Failures
by
crown
2 hours, 35 minutes ago -
Windows 10 23H2 Good to Update to ?
by
jkitc
2 hours, 38 minutes ago -
At last – installation of 24H2
by
Botswana12
1 day, 4 hours ago -
MS-DEFCON 4: As good as it gets
by
Susan Bradley
2 hours, 25 minutes ago -
RyTuneX optimize Windows 10/11 tool
by
Alex5723
1 day, 17 hours ago -
Can I just update from Win11 22H2 to 23H2?
by
Dave Easley
1 day, 10 hours ago -
Limited account permission error related to Windows Update
by
gtd12345
2 days, 6 hours ago -
Another test post
by
gtd12345
2 days, 6 hours ago -
Connect to someone else computer
by
wadeer
2 days, 1 hour ago -
Limit on User names?
by
CWBillow
2 days, 4 hours ago -
Choose the right apps for traveling
by
Peter Deegan
1 day, 18 hours ago -
BitLocker rears its head
by
Susan Bradley
1 day, 2 hours ago -
Who are you? (2025 edition)
by
Will Fastie
1 day, 1 hour ago -
AskWoody at the computer museum, round two
by
Will Fastie
1 day, 20 hours ago -
A smarter, simpler Firefox address bar
by
Alex5723
2 days, 16 hours ago -
Woody
by
Scott
3 days, 2 hours ago -
24H2 has suppressed my favoured spider
by
Davidhs
1 day, 1 hour ago -
GeForce RTX 5060 in certain motherboards could experience blank screens
by
Alex5723
3 days, 16 hours ago -
MS Office 365 Home on MAC
by
MickIver
3 days, 10 hours ago -
Google’s Veo3 video generator. Before you ask: yes, everything is AI here
by
Alex5723
4 days, 6 hours ago -
Flash Drive Eject Error for Still In Use
by
J9438
1 day, 1 hour ago -
Windows 11 Insider Preview build 27863 released to Canary
by
joep517
5 days, 1 hour ago -
Windows 11 Insider Preview build 26120.4161 (24H2) released to BETA
by
joep517
5 days, 1 hour ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.