Jump to content

Ryszard Gold

Members
  • Content Count

    23
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ryszard Gold

  • Rank
    novice
  1. Hey there folks, wondering if there is a way to pull a photo in a Container Field through a relationship? I'm producing a Family Menue planner that has 3 tables, one for ingredients, one for meals, and the planner itself. The meals table has the title description, list of ingredients, and finally a photo of the dish. On the actual planner table I want the user to be able to select the menu item for the time of day, and have it pull the photo through a display it in a field once the item has been selected. I tried through Auto Enter, and it doesn't seem to want to work on a conta
  2. This thread seemed to die a painfull death, so I'm trying again! I've investigated some results on things like "Finds across multiple tables", "Reports from mulitple tables", and the vast majority of results come from very sophisticated developers using vast scrips and cryptic field names. My Goal: To have a seperate layout where my cleint can go, put in a beginning date and end date....either hit a search button or have the system dynamically show the search results (in a portal?) and have the system automatically do a sum calculation. If the results from the invoice and
  3. I've investigated some results on things like "Finds across multiple tables", "Reports from mulitple tables", and the vast majority of results come from very sophisticated developers using vast scrips and cryptic field names. My Goal: To have a seperate layout where my cleint can go, put in a beginning date and end date....either hit a search button or have the system dynamically show the search results (in a portal?) and have the system automatically do a sum calculation. If the results from the invoice and expense table have to be shown seperatly, so be it, as long as I can
  4. Mind letting me in on the process? This would have to be dynamic as this is something he'd want to do once or twice a month at least. How do you have FM import data from itself then?
  5. It's me again folks, hoping I get some advice before I dive into the next section of my database here. My client wan't to be able to print out a report of his expenses and invoices to take to his accountant. I have an invoice table and a expenses table. I know I preform a find function, but I was hoping I can get this to generate a form of some sort where he puts in the beginning date and an end date, and the search pulls records from BOTH databases, sorts them by data (both records togethor) then finally does a tally at the end. Where would I start?:
  6. Hey, that is exactly what I had going on at the very frigging beginning! When I didn't have need of thinning out the selection, back to basics and I didn't even see it! Forest through the trees kinda thing! Thanks again, and thanks for explaining, that helps! I'm sure I'll have more in the future, but thanks so much!
  7. I'm pretty sure I did what you asked, made another instance of the table, and linked them as before but with one more relationship to product ID. I didn't seem to work. I checked that I had the order correct, seemed to be. I noticed it was forcing a one to many relationship because of the auto-serial trait of ProductID. Have a look and give me another hint? LJCT_1.4.fp7.zip
  8. I can understand what you mean, but now how you do it. Please describe what fields I would use, or what relationship I would alter. I'm sorry, I understand the problem, but not the method.
  9. That I know, you may have been seeing my "try bloody anything, just make it show up!" thing. How do I go about populating the ProductID-fk then? Do I have to add another instance of the table? Please keep in mind I'm still green at this, so I need a little meat with my potatoes of instruction. Can you describe how I do this?
  10. You know, I really wish I was done this, and I wish I was capable of doing this myself! This should be very simple, but for some reason, the simple wais simply not working! Because of the hierarchal menus, it will not pull through or display my Order_line_price from the Products table, with that, it is supposed to calculate the extended price based on that times quantity. For some reason, the only time I ever managed to get a value in there, it was bring generated before you selected the description drop down...it was taking the first price from the list of Categories, Subcategory t
  11. DEAR GOD THANK YOU! For real, thanks! I see how that all works now, I may be slow on the uptake, but eventually this will all make sense!
  12. I've tried changing the relationship, but I admit, I'm still lost! I have tried linking the manufacture field of one Products table instance to another instance of the same table then to Orderline, but it still does not seem to filter it, getting all manufactures. I'm still very green at this, so I'm sorry if it's like talking to a brick!
  13. That makes sense, though I am unable to find out where I can do that, I don't seem to find any further options in the Value List windows, or is this something I have to do in the Tables Relatiosnhip?
  14. Ok, definatly getting there! I did what you had done, and it does indeed SEEM to work, though there are some quirks...mind having a look? If you look on invoice 18, your filtering seems to work flawlessly, but when you get to manufacture and description drop downs, they don't always bring up the proper stuff, or to much stuff. For instance, line 5, Selecting beverages, then water...you get Pepsi Co and Coca-Cola Co, if you select Pepsi Co, you get all of the pepsi co products, not just the water from them. Line 8, selected portioned coffee, then Ghost, brings up Club as the on
×
×
  • Create New...

Important Information

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