Newbies TLR Posted February 23, 2006 Newbies Posted February 23, 2006 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 Posted February 23, 2006 Posted February 23, 2006 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 Posted February 23, 2006 Posted February 23, 2006 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
Newbies TLR Posted February 23, 2006 Author Newbies Posted February 23, 2006 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
Newbies TLR Posted February 23, 2006 Author Newbies Posted February 23, 2006 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
Recommended Posts
This topic is 6864 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now