Hello people,
I'm fairly new to access and DB programming in general. I am familiar with the "basics" of MS Access, forms, tables, queries, macros, and such, but still don't have everything down pat.
What I am attempting is to create a database which stores client information linked to particular reps detailing dates, financial info, addresses and such. Instead of creating a flat table with all this info inside it, controlled by forms and queries, I wish to divide the data into multiple tables based on project timelines and have one major form act as the data entry front end for all project tables. I also wish to have a separate global table just detailing customer contact info where any customer id can be related to any one or more records in the various project tables.
ie.
table custinfo - storing all customer contact info, nothing else
table project1 - records related to unique identifier in "custinfo" table but only concerning information relative to this project... $$$ totals, dates, etc...
table project2 - likewise, except only dealing with this unique project and the client relations with.
table project 3, and so on... as each project comes into existence, a new table will be created with the same criteria… manually I suppose.
form frontend (whatever the name) - this needs to act as a master form where data can be entered regarding a new client (data to be routed to table "custinfo") and some sort of subform(s) which can link to the various project tables (or a way where a customer name, id can be entered to bring up a display of all client activity if the user so chooses, or a particular project (perhaps determined by a dynamic query?)
I also need to create reports on all the above, both totals within project tables as well as across project tables.
Any suggestions on table structure, or relationships would be greatly appreciated. I've already created the tables, but am stuck on the relationships and/or linking tables.
MS Access 2003//Windows XP latest patches
Thank you for any help you can provide!!! ;-)
- BSM ->
2 1720 PEB 1,418
Recognized Expert Top Contributor
Hey man,
But you can have tousound projects... For each project you will create a table??? with the same structure like the tables with the projects before???? And why simply you don't create a table projects with a column Project Name??? Isn't it more easy??? Only one table with projects?
Best regards
MMcCarthy 14,534
Recognized Expert Moderator MVP
You can have a projects table with a list of projects and there associated fields and and projects details table with with the fields to record incidents/milestones on the project. I would actually have a different table for each type of record.
Give us some breakdown of the type of information you need to record on each project and we will try to help further.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Bose |
last post by:
Hi
I have to make export of SQL Server Database to MS Access and I have
done it with the tables but now I need to transfer(export) the
relations, keys and indexes. Can any1 tell me how to read relations,keys
and indexes from SQL Server and convert them to MS Access.(it seams that
for creation of indexes in MS Access ADOX is the only way but ADOX
cannot read all information about keys,indexes from SQL Server.)
All I can see is that I have...
|
by: Bart |
last post by:
Hello
I am looking for something like visual database structure browser. I
need to see all tables and relations beetween them. Something like
"Relations" window in Microsoft database products (ex. msaccess).
I have to work with complicated database and i need to understand fast
how it works.
Greetings,
|
by: jan |
last post by:
Hello,
I am new to this list and would appreciate some help with Access 2000
and Access 2003. I need to export our access database table statements
by access database to place into our database model repository. We have
several different relational databases, of which access is one, so we
want to keep all of the SQL that creates tables in a single model
repository. Is there some way within the access tool to export this
information? I...
|
by: news.giganews.com |
last post by:
Does anyone know if there's an easy way to export or copy the relationship
structure from one mdb to a new one? The relationships in the db are time
consuming to reproduce. I am trying to make a copy of a database including
all the relationships, forms, queries and modules while still within the
original database. This has to be a relatively automated process (button
click). Any suggestions?
|
by: vsiat |
last post by:
I am trying to create a treeview out of a database table
with the typical structure ID, NAME, PARENTID, TYPE,
EXTRA_INFO, where is linked to the .
What I want to achieve is create a tree made of custom,
extended nodes, which include all the extra information
contained in the table and not just typical TreeNode
objects.
To do that, I first created a structure with all the extra
| |
by: mesut |
last post by:
Mybe it's a stupid question but :
I'm starting to learn VB.NET. I have some basic skills. I'm from
Mainframe world and I have same question to make my DATABASES (tables
and relation)
I would like to make ask my question by example. Let's say I'm a
sales company I'm selling products to customers. Okay?
I have these tables (databases) and fields and I have these questions.
I have created these tables in VB.NET Database Connections IDE...
|
by: learning_codes |
last post by:
Hi ,
I'm wondering if there is a way for me to export some tables including
data and structure from old database to a new database and then save as
new database name.
I try to create a marco and it create a new table within the same
database.
I would be appreciated if you can help me to create a code for one
|
by: Jo |
last post by:
Hi there,
I'm Jo and it's the first time I've posted here. I'm in process of creating
a database at work and have come a little unstuck.....I'm a bit of a novice
and wondered if anyone could help. I work in a library and send out dual
language books to babies of dual or other nationality.
The db is to be used for logging a range of book titles and numbers ordered
and books sent out to individuals. I am trying to work out a way of...
|
by: Phil Stanton |
last post by:
I have 1 FE database which can be linked to a number of BE databases. The
BEs are all different Clubs e.g. Sailing Club, Yacht Club, Bridge Club,
Family etc.
Problem is if I change anything in the table structure or relationship of
one of these clubs, I want to make sure I do it with the other clubs as
well.
Has anyone got routine that will check that each BE database has
1) All the tables (even though some will be empty e.g. Bridge...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |