multiple data in one field

[TLR]

Hi,

Sorry if this is a silly question. I'm fairly new and i thought a repeating field could help, but it's not working for me....

I have a database of cabs for four states. Some of those cabs are part of a fleet. Which means that in One record there may be multiple cab numbers.

How can i show that? I tried a repeating field, but it's not even showing up in browse mode for me to click on and enter the different cab numbers. So at the moment for all of those fleets that have multiple cab numbers, i have them in one field, all together.

I need them to show up as a list too, but i'll ask that later....

[Wim Decorte]

No question is silly, so feel free.

We probably need to have a look at how your solution is built, can you give us an overview or your tables and what kind of data is in each one? What relationships you have going (in your data of course.. )

[Genx]

Repeating fields arent really used for this sort of thing anymore. What you want to do is create another table and relate it to your first one. So lets say you have 3 tables.

Table 1 --> A table of states

Table 2 --> A table of Fleets

Table 3 --> a Table of cabs

You would relate each of these tables to each other successively. Table 1 = Table 2 (by state)

Table 2 = Table 3 (by primary key in table 2 and foreign / related / relational etc. key in table 3)

Then you could use a tool called a portal (it allows you to display multiple related records) within fleet to display all cabs belonging to that fleet, or add new ones (to do this, go into define database, relationships and on the relationship between fleet and cab [T2 & T3] double click and set add new records on the T3 side of the relationship to yes). This is all assuming you dont want detailed information about the cabs, if you do i dont suggest adding them through a portal, but rather creating another layout to do this.

Anyway you could also put a portal in T1 table occurance to display fleets within the state and cabs within the state.

This sort of thing is a bit difficult to explain so if you require a sample file, let us know

~Genx

[TLR]

Ok. I thought that would be the case and I started to do go that route and created tables for Market, Payment and Medallions each, but then i deleted them, because i used the Medallion number as the relationship and it wasn't working. -

I've attached a copy of the file. I don't expect you to fix it, but if you can guide me in the right direction i'd appreciate it so much :

drivers_Copy.zip

[TLR]

basically what i want is to be able to perform a find and list all or some of the medallion numbers for one particular record.

Let's say i only need two medallions that belong to the same record, but that record has 10 different medallion numbers , i'd like that record to show up either twice (one for each medallion number) or show up once with the two medallions listed below the name or something....

i.e., in the layout i have for NoComm, in that particular record i only need two of those medallions to to be on the NoComm list, not all of them.

i feel like i'm confusing myself... lol