Jump to content

Lizzy

Members
  • Content Count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Lizzy

  • Rank
    novice
  1. Thanks Tusif, I'm not sure the company this is for would allow that the contact lists be passed onto a third party, but I can certainly check into that some more. I'm really just looking for assistance on the script steps, if you could help with that it would be much appreciated. Anyway, post back your email if it's not on your profile and i'll send direct if you are interested in helping out there... Thanks again,
  2. Thanks for the quick reply... I was thinking of something along those lines for the displaying of the address in the contacts layout, but the solution I need for now is how to import multiple excel spreadsheets, so it creates records in the addresses table (but not dup's of the contact names). And then using calc's to filter the most recent address, dependent on a date field. I've about 200 spreadsheets to import... Sorry, my original post wasn't so clear... I'm working on an Events Database, and if we can track where people have lived, we can target them specifically in Mar
  3. Wondering if someone could point me in the right direction of keeping a list of addresses that my contacts have lived at. I've looked at some of the starter solutions, but they only allow for second addresses, or a business and a home address etc... I import from excel as information is given to me, and would like to import it, have FMP find the contact, if their address in the excel spreadsheet is not the same as their existing address in our database then have FMP add the new address as a new record in a addresses table, which is linked via their ContactID... Many thanks in adva
  4. Hello to All! I posted this in portals, but in retrospect, its a relationship thing... Any suggestions would be gratefully recieved... With thanks ------------- Hiya... I'm working on an Event's database, that incorporates attendees info, events and the people who organize events. Event teams tend to be fairly static with people repeating roles regularly. As they are an Event team member, they also show up in the attendees table, as they've attended an Event. I'm wanting to display events that individual attendees have been involved with, and the specific ro
  5. Hiya... I'm working on an Event's database, that incorporates attendees info, events and the people who organize events. Event teams tend to be fairly static with people repeating roles regularly. As they are an Event team member, they also show up in the attendees table, as they've attended an Event. I'm wanting to display events that individual attendees have been involved with, and the specific role they played... ie, Jane Smith 'ORGANISED' 'EventID' 001 & 'ASSISTED' 'EventID' 002, on the Attendees / Contacts layout. So far I can display through a portal Event Team da
  6. Fenton Fenton! It worked, it worked! Lol! Took a little tweaking, but the skeleton was all there, and thanks to you it's now a one-button process. Yah! Duplicates causing a few issues, but I think that is more on the initial data entry rather than the scripting process. Am onto the EventTeam bit now Thanks again...
  7. The mechanics of assigning the EventID are coming together... I've been tossing with the idea of adding a table especially for the different aspects / member levels to the company, or whether to use a check box to list them, and assign that as a category to the "Attendees" It's not going to work, as one "Attendee" can fall into too many categories. The company basically, have two functions 1) Host events, 2) Train ppl to hold events. The general flow goes like this: "Attendee" goes to an event > they usually do one of two things a) go again don't... If they go again they may go on t
  8. How do i build a many2many structure join free...? I've not heard that before, what would the benefits be, and what circumstances could it be applied in? Do they contain global fields too lol!
  9. cool! thanks for the replies. Sorry for the vaugity (lizzy-ism), around the original post, Attendees are sometimes in the attendees table as, an 'Organiser' for example, always has been to the Event initially as an attendee. There are always at least 7 duplicate records on every import, as those ppl are the 'team' behind the event. To a maximum of 23 at each event. So, in saying that, duplicates could become an issue. My original post was around the table occurance group. Do I need to create a group designed only for the new layout (i.e.New Event/Registration...) The
  10. Ok... Isn't there an easier way... lol! My thinking was along the lines of building an import script. I always import from the same file as some of the excel doc's i recieve are ... well rather creative! In the script, window pops up, asks what event ID number the records relate to, and then the event ID is assigned. We have hundreds of events and I'm importing records from 1996...
  11. Hiya, I have two tables, one called "Events" and once called "Attendees", that link through a join table called "Registrations". So far, they are set as many to many in the relationship graph, as many attendees attend an event, and attendees attend many events. That's all working great. I receive a list of Attendees from an Organizer (value list), and import those contacts into the database. I would like to create a layout, and a script to automatically assign the Event they attended to the group of imported Attendees. How do I go about building the Table Occurrence Group on
  12. Hiya, I've got three tables; Table 1 is Events & Table 2 is Participants. Table 3 which links them all is Registrations. Using the Missing Manual book, I created this database as a data tunneling interface... Each have portals on the layout. Layout 1 for Events lists in a portal, the people attending the event. Layout 2 shows the Participant details and then lists all events they've been at. On the Participants layout I go go to the related event, and the script is working fine. On the Event layout, I can't go to the related participant record. It comes up with an err
  13. Hi Al, Just wanted to say thanks for the help with the serial numbering, that worked a treat. Amazes me how when I think something is going to be rather complex in FMP, it rarely actually is lol! Cheers ;)
  14. Ok! I'll try both suggestions and see how it all works... The database I'm working on atm, is for an organization who are very community orientated. My way of thinking is to have one core database, and then manage individual countries from the main. But alas, it seems that's not going to happen, for company reasons etc... Until now, our serial numbers haven't been an issue, and as a contact is added their number is auto generated. They have recently created an online market place for their community, and the serial number is a core element to managing the accounts for this
  15. Hi to all, Wondering if anyone can help with an issue I've got with serial numbers. I'm new to databasing so it could be an easy thing... Maybe not! What would the calculation steps be in creating a serial number that included letters as well as numbers, and those letters being the result of information checked in a radio set? For eg... An Australian contact who attended a training event I would like their serial number to be A (for OZ)+ 001 (serial number)+ T (training event). With the result looking like this A001T Thanks... :(
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.