473,513 Members | 2,576 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

I need a structure that can grow in two directions

1 New Member
I'm developing a multi-user DB in Access and I need help structuring some of the information. I have a list of events stored in one table and a list of capabilities stored in a second table
The tricky part is that I need to be able to specify (via a check box) which capabilities are needed for each event. Both the capabilities and events are dynamically expanding sets (when a user determines a new event or capability they need to be able to add it to the DB and have it available to all other users immediately)
I'm fairly competent with Access and VB, but I'm having a hard time structuring this to work in a real-time multi-user environment. Any ideas?
Jun 17 '07 #1
1 1116
dima69
181 Recognized Expert New Member
I'm developing a multi-user DB in Access and I need help structuring some of the information. I have a list of events stored in one table and a list of capabilities stored in a second table
The tricky part is that I need to be able to specify (via a check box) which capabilities are needed for each event. Both the capabilities and events are dynamically expanding sets (when a user determines a new event or capability they need to be able to add it to the DB and have it available to all other users immediately)
I'm fairly competent with Access and VB, but I'm having a hard time structuring this to work in a real-time multi-user environment. Any ideas?
The way I see it is this.
In addition of the two tables ("tblEvents" - all events and "tblCapab" - all available capabilities) you will need a third table, determining the connection of the previous two - lets call it tblCapab2Events. The fields of that table are:
Expand|Select|Wrap|Line Numbers
  1. Id - Autonumber
  2. Event_Id - ID of the event
  3. Capab_Id - ID of the capability
Each record of tblCapab2Events will contain capability Capab_Id needed for event Event_Id
The drawback of that method is that it will be hard to implement via check boxes. The natural implementation here will be by Main form (Events) with Subform (tblCapab2Events) showing all capabilities needed to current event.
Jun 17 '07 #2

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

Similar topics

18
1843
by: alex | last post by:
Hi there, how can I check if a variable is a structure (i.e. a list)? For my special problem the variable is either a character string OR a list of character strings line So how can I test if a variable 'a' is either a single character string or a list? I tried: if a is list:
6
3602
by: Vagif Abilov | last post by:
We decided to adopt .NET coding guidelines posted by Brad Abrams from Microsoft: http://blogs.msdn.com/brada/archive/2005/01/26/361369.aspx Here is what Brad (and AFAIK Microsoft) suggests regarding project folder structure: "Directory names should follow the namespace for the class For example, I would expect to find the public class...
1
2817
by: jana | last post by:
Hello all, I am unable to open a map image on Mapquest.com. From the "Directions" button, When I enter the From and To address informations, I click on "Get Directions", the steps appears but the "Map" button does not open the step by step map image. All what appears is a red X in the upper left corner of the image area. Has any one...
24
6547
by: John | last post by:
I know this is a very fundamental question. I am still quite confused if the program call stack stack should always grows upwards from the bottom, or the opposite, or doesn't matter?? That means the stack pointer should go upwards when there are "push" operations, and stack pointer should go downards when there are "pop" operations?? If...
1
1498
by: nemesia31 | last post by:
i have a structure typedef struct tm { int date; int hour; int minutes; } time; i want to use this structure dynamically, ie, i want it to grow.
4
1781
by: Bas Wassink | last post by:
Hello all, I've been wondering about struct member names and reserved identifiers for some time now and I can't figure out whether the reserved identifier restrictions apply to struct members. I think the following is allowed: struct foo { unsigned char *memory;
2
1613
by: jdvictor | last post by:
Understandably I know that the real issue is in IE but at the moment everything looks good in IE and not Firefox. THE PROBLEM The problem that I am having is that my navigation menu is out of wack when viewing it in Firefox the browser seems to be pushing everything on the right to the left and I can't for the life of me solve the problem....
7
1788
by: erikcw | last post by:
Hi, I'm working on a web application where each user will be creating several "projects" in there account, each with 1,000-50,000 objects. Each object will consist of a unique name, an id, and some meta data. The number of objects will grow and shrink as the user works with their project. I'm trying to decided whether to store the...
9
2614
by: pereges | last post by:
Hello I need some ideas for designing a recursive function for my ray tracing program. The idea behind ray tracing is to follow the electromagnetic rays from the source, as they hit the object.The object is triangulated. The rays can undergo multiple reflections, diffractions etc of the same object i.e. a ray hits a surface of the object,...
0
7178
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...
0
7397
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, 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. ...
0
7565
jinu1996
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...
0
7543
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 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...
1
5103
isladogs
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...
0
3255
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3242
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1612
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
817
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.