Hi there, I'll try to describe in how this database is supposed to be laid out, I"ll give field name, type, and description Vehicle is from: choice Provides a drop-down of three possible choices upsbrown/upsfreight/upssupplychain receive date: unsure of field type field used to enter date pertaining to when vehicle was purchased Unit number: unsure of field type provides a number used to identify the vehicle Location: Address field provides the current location where the vehicle is waiting for pickup vehicle type: choice provides a drop down list as to what kind of vehicle it is. tractor/trailer/dolly/packagecar/forklift/pickuptruck Vehicle running: choice provides a drop-down with two options yes/no Vehicle will be: choice provides two options exported/delivered to disposal location UPS contact: not sure of field type provides where to put the name of the point of contact that can be called about this vehicle Contractor: ideally choice, if choices could be made to populate name and address of contractor who is going to pick up vehicle once choice is selected. Deliver to: choice a drop-down of choices that would denote where vehicle was going. Only about eight possible places they can go. Would love if address of deliver to location could be populated if choice is selected. delivery date: unsure of field type field used to enter date of delivery of vehicle The goal is to be able to take this database, and if needed export it out to a .csv file if somebody needs to see what's going on and/or needs to pull this up in excel. I see in bento where you can create a new library from a blank template, and I've done this. Then comes the adding fields part which is the area that I think I'm having trouble. I press the "add new field" button, and I choose whether this field is going to be text/number/choice/checkbox/whatever, and then I name the field. if I use the choice option, I'm presented with a button beside the field name edit box that give me options to enter choice1/choice2/etc. I hope this all makes sense. I hope this provides a bit more clarification as to what I'm asking for. Thanks, Justin
Thanks for any help you can give, Justin On Nov 14, 2011, at 8:55 PM, Bryan Jones wrote: > Hello Justin, > > I'd like to help but need a little clarification first, if you don't mind: > 1. Regarding the popup: Are you using what bento calls a "Choice" field? > 2. When you say you're unable to make the popups behave as they should, can > you give some exact details of how you think they should behave and maybe > list the steps you've taken so far and the results you're getting? > 3. I'm not clear on your question regarding the number field. Can you give an > example to show what you mean about a number that is used to look up > information? > > Cheers, > Bryan > > > On Nov 14, 2011, at 6:51 PM, Justin Mann wrote: >> I am creating a database in bento and the process seems straight forward. >> However, I'm not able to affectively make the pop-ups behave like they >> should. I'm also trying to figure out what field to use where. Do you use >> a number field to store a number that is used to look up information? Can >> this be done in text field? > > <--- Mac Access At Mac Access Dot Net ---> > > To reply to this post, please address your message to > mac-access@mac-access.net > > You can find an archive of all messages posted to the Mac-Access forum at > either the list's own dedicated web archive: > <http://mail.tft-bbs.co.uk/pipermail/mac-access/index.html> > or at the public Mail Archive: > <http://www.mail-archive.com/mac-access@mac-access.net/>. > Subscribe to the list's RSS feed from: > <http://www.mail-archive.com/mac-access@mac-access.net/maillist.xml> > > The Mac-Access mailing list is guaranteed malware, spyware, Trojan, virus and > worm-free! > > Please remember to update your membership options periodically by visiting > the list website at: > <http://mail.tft-bbs.co.uk/mailman/listinfo/mac-access/options/> <--- Mac Access At Mac Access Dot Net ---> To reply to this post, please address your message to mac-access@mac-access.net You can find an archive of all messages posted to the Mac-Access forum at either the list's own dedicated web archive: <http://mail.tft-bbs.co.uk/pipermail/mac-access/index.html> or at the public Mail Archive: <http://www.mail-archive.com/mac-access@mac-access.net/>. Subscribe to the list's RSS feed from: <http://www.mail-archive.com/mac-access@mac-access.net/maillist.xml> The Mac-Access mailing list is guaranteed malware, spyware, Trojan, virus and worm-free! Please remember to update your membership options periodically by visiting the list website at: <http://mail.tft-bbs.co.uk/mailman/listinfo/mac-access/options/>
