473,325 Members | 2,308 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,325 software developers and data experts.

Double one to many....PLEASE READ

Okay, so this is my situation. I have a database that stores clients and
their corresponding groups. (We're an insurance brokerage, so we have each
company's information and each of their clients' information). One of the
features of this database is to track mailouts and newsletters. I have a form
to add individual clients to the mailouts, but I would like to also be able
to choose a company and have it populate ALL of the employee's mailouts to
show that each employee recieved the mailout.

Here's my table layout:
GROUPS - GroupID (primarykey), GroupName, etc...
GROUPMAILOUTS - GroupID, MailoutID
EMPLOYEES - EmployeeID (primarykey), GroupID, FirstName, LastName, etc...
EMPLOYEEMAILOUTS - EmployeeID, MailoutID
MAILOUTS - MailoutID (primarykey), MailoutDate, MailoutName, File (OLEobject)

Relationships:
Groups ---> Employees (one group, many employees)
Mailouts ---> EmployeeMailouts, GroupMailouts (one mailout, many employees
and groups can recieve it)
Employees ---> EmployeeMailouts (each employee can have many mailouts)
Groups ---> GroupMailouts (each group can have many mailouts)

When a group is chosen, the GroupMailouts table will be populated with the
groupID and the mailoutID. When you choose this group, I want it to not only
populate the GroupMailouts table with the groupID and the mailoutID, but also
populate the EmployeeMailouts table with each person in that group's
employeeID and the mailoutID.

I have a form that you can input the mailout's name, date, and upload the
file. On the same form, I have a subform where you can choose individual
employees to receive that mailout. I would like to be able to choose a group
and have it automatically put all the employees from that group in the
subform.

I have an employee form that shows all the information for each employee,
including dependents, policies, and mailouts recieved. I have a subform that
shows all the mailouts for that person. If we choose just a group without the
automatic population, it won't show in this subform.

How do I do this?? Someone help, please!

--
Message posted via http://www.accessmonster.com
May 16 '06 #1
2 1278
how to show all members of mailing list... use an append query....

Basically, show all the members of whatever group you're selecting from
your combobox. then create an append query to append all of those to
the subform table. Call it in the OnChange (?) event of the combobox
You might want to prompty the user for the standard "Are you sure?" so
that you don't accidentally add lots of records you didn't intend to.

May 17 '06 #2
The append query worked perfectly. I added a msg box in the code and if yes=
run the append query. Thanks!

pi********@hotmail.com wrote:
how to show all members of mailing list... use an append query....

Basically, show all the members of whatever group you're selecting from
your combobox. then create an append query to append all of those to
the subform table. Call it in the OnChange (?) event of the combobox
You might want to prompty the user for the standard "Are you sure?" so
that you don't accidentally add lots of records you didn't intend to.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 17 '06 #3

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

Similar topics

10
by: Carlos Ribeiro | last post by:
Hello all. I'm sending this to the list because I would like to know if someone else has ever stumbled across this one, and also because one possible solution is to patch, or simply "decorate",...
2
by: Diarmaid McGleenan | last post by:
Hi all. This isn't quite the same single/double-quote problem we see posted a multitude of times in this ng. Read on... I have a js function called ShowActiveLink which accepts a string...
33
by: Daniel Fadlun | last post by:
Is there a bigger, mathematical, data type in C than the double (64 bit) one or the old long double (80 bit)? I'd like to add precision to my mathematical application, but I can't figure out how....
16
by: Charles Law | last post by:
I have a string similar to the following: " MyString 40 "Hello world" all " It contains white space that may be spaces or tabs, or a combination, and I want to produce an array...
5
by: soeren | last post by:
Hello, two days ago I stumbled across a very strange problem that came up when we were printing tiny double numbers as strings and trying to read them on another place. This is part of an object...
13
by: Shirsoft | last post by:
I have a 32 bit intel and 64 bit AMD machine. There is a rounding error in the 8th digit. Unfortunately because of the algorithm we use, the errors percolate into higher digits. C++ code is...
29
by: Virtual_X | last post by:
As in IEEE754 double consist of sign bit 11 bits for exponent 52 bits for fraction i write this code to print double parts as it explained in ieee754 i want to know if the code contain any...
206
by: md | last post by:
Hi Does any body know, how to round a double value with a specific number of digits after the decimal points? A function like this: RoundMyDouble (double &value, short numberOfPrecisions) ...
22
by: Bill Reid | last post by:
I just noticed that my "improved" version of sscanf() doesn't assign floating point numbers properly if the variable assigned to is declared as a "float" rather than a "double". (This never...
1
by: Yearwood | last post by:
Hi, I'm basically trying to import a CSV into an ACCESS database. Sample date is shown below: "",10173,"Development Manager - Social Economy Sector","Trust Bank",10153,,"Lolalll Pudd","Meet the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.