More table trouble

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Consider a grid with 20 spaces, Space A, Space B etc. In each space I
want to list a persons name and a date. I would like the data entry to
be on a form graphically.
Do I set up one table with fields SpaceA-Name, SpaceA-Date, SpaceB-
Name, SpaceB-Date etc.? This would certainly make it easier in
designing the form and making sure the data goes to the right field,
but it's probably poor table design. Or do I use separate tables? And
then how do I set up the form with the proper record sources?
My brain hurts.

Thanks,
Dave B
 
Consider a grid with 20 spaces, Space A, Space B etc. In each space I
want to list a persons name and a date. I would like the data entry to
be on a form graphically.
Do I set up one table with fields SpaceA-Name, SpaceA-Date, SpaceB-
Name, SpaceB-Date etc.? This would certainly make it easier in
designing the form and making sure the data goes to the right field,
but it's probably poor table design. Or do I use separate tables? And
then how do I set up the form with the proper record sources?
My brain hurts.

Thanks,
Dave B
Click to expand...


Unless you can make a really good case for it, I would consider it
poor design to do so. Queries and reports would be awkward at best.
Why would you want to use that kind of format?
 
Unless you can make a really good case for it, I would consider it
poor design to do so. Queries and reports would be awkward at best.
Why would you want to use that kind of format?
Click to expand...

I don't want to use that kind of format. I just don't know how to
proceed with the best way.

Thanks for the reply,

Dave B
 
If you are assigning seating for a theatrical production for example, you
would assign each seat a row number and a column number. That means that if
you have 20 rows, each with 10 seats, you would have 200 rows in your table
for each performance. One row for each seat. If you want to display the
data in a two dimensional view, use a crosstab but don't do your data entry
that way unless you use an unbound form.
 
What I guess I should have asked is, what is the goal? If all the
table is storing is a name and a date, then these (plus perhaps some
unique ID field, and split the first and last names into separate
fields) would be the only fields in the table.

IDField / FirstName / LastName / RecDate (don't use just "Date" as
the name)

Again the goal of this would likely dictate how you present, filter
and enter this data.
 
What I guess I should have asked is, what is the goal? If all the
table is storing is a name and a date, then these (plus perhaps some
unique ID field, and split the first and last names into separate
fields) would be the only fields in the table.

IDField / FirstName / LastName / RecDate (don't use just "Date" as
the name)

Again the goal of this would likely dictate how you present, filter
and enter this data.
Click to expand...

I need to store the names, dates and the location. In simple table
that would be easy, but the important part is to be able to enter the
data on a graphical form. Using the theater example from above, I
would like to type the persons name and date in each seat of the
theater and the table indicate the seat, the name and the date. For
instance, if I have a control representing seat 1, and type in the
name and date, is the name and date under the field "seat 1" (If so,
there would need to be 200 fields, (20 rows with 10 seats)). Or do I
have fields "seat", "name" and "date". Which seems to me to be better
table design, BUT if I do this and type in the name and date in the
control for seat1 how does the program place "seat1" in the field
"seat". It's probably very easy and I'm just too blind to see it.

Dave B
 
Dave

As the previous posts have said you would create a table to hold the
persons name, the row number, seat number and date. To display the
data on screen in a graphical format you could use a Flex Grid
control. Have a look at -
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'
for some examples. Post back if you need any more help on using a Flex
Grid control.

HTH

Peter Hibbs.

On Fri, 9 Mar 2007 08:52:43 -0500, "Pat Hartman \(MVP\)" <please no
 
Back
Top