473,396 Members | 2,140 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.

Forms that populate data in many-to-many relationships

So I'm making a form in access. I want it to book members for events, and the individuals table and events table is connected through a linking table:

[Members]--[Eventlnk]--[EventDetails]

What's happening right now is that I can see the events that members previously booked to, but I can't add any new event bookings. I've so far tried to use queries to run the forms. I am trying to finish the form by Friday, so any help would be appreciated. Thanks!
Aug 1 '07 #1
3 1393
Rabbit
12,516 Expert Mod 8TB
What's your form's record source? If it's a query, what's the SQL?

You should also avoid many-to-many relationships, they just cause too many problems and isn't good table design.
Aug 1 '07 #2
The Record Source for my form is a query.


The SQL for that Query is the following:

SELECT EventDetails.*, EventLink.Attendee_ID
FROM EventDetails LEFT JOIN EventLink ON EventDetails.EventCode = EventLink.EventCode;
Aug 2 '07 #3
Rabbit
12,516 Expert Mod 8TB
A many-to-many join is non-updateable. you should be using a subform instead.
Aug 2 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Greg Lindstrom | last post by:
Greetings- I have been asked if I can populate existing Forms in a Microsoft Word Document. I have the book Python Programming on Win 32 (Hammond/Robinson) which addresses Microsoft products,...
1
by: Viktor Zadro | last post by:
When populate grid with data from dataset: 1. Public Sub New().. Or 2. Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
1
by: Mark Goldin | last post by:
How can I populate a dropdownlist with data from a database using Microsoft.ApplicationBlocks.Data ? Thanks
16
by: Mike Fellows | last post by:
when i load my windows form i populate a combobox i use the code below Dim conn As New System.Data.SqlClient.SqlConnection(strConn) Dim sql As String = "AllLenders" Dim da As New...
0
by: ROO | last post by:
Hi Everyone, I have a database table that have 4 field( C1, C2, M1, M2) on my form i have two combo box ComboC and ComboM C1 C2 M1 M2 1 ...
0
by: Ashkan Daie | last post by:
Hi All, When using forms authentication with IIS 6.0, I can create a user and log in the user. But the LoginStatus control states that the user is logged out. When running the same app using...
0
by: Ashkan Daie | last post by:
Hi All, When using forms authentication with IIS 6.0, I can create a user and log in the user. But the LoginStatus control states that the user is logged out. When running the same app using...
2
by: weiwei | last post by:
Hi I am trying query the data from db and populate in the web form's textbox field. so far I cannot put that record into the text field box. anyone has idea on that, below is my sample code...
7
by: Simon Gare | last post by:
Hi, have form on asp page that recalls data from the recordset and populates all the fields except the dynamic dropdown box that doesn't, just shows default value. How do I make it populate...
6
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
When I check the syntax of dataset, It seems that dataset can only read data from file. (e.g., datset.read(string filename), dataset.readxml(string filename)). If I have a string with XML format...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.