I'm fairly experienced with database systems, but new to A5. I'm converting an application from Lotus Approach to A5, and, initially, we're trying to do it as quickly as possible - i.e., probably not taking advantage of some of the niceties of A5. I've got two specific problems that don't seem to be mentioned in the forum.
1 - I'm trying to create a set involving "line item".dbf, invoice.dbf, and "buyer data".dbf. Invoice is the root, and buyer data, and line item are each sub-tables of invoice. All is ok until I try to add "line item". Everything seems OK except that no list of columns pops up to let me create the link between invoice and line item. I've checked column data types , etc. and it all seems ok. I don't get any sort of error message, just no selection of columns to link on. If I make line item to root I can make the links, however, that causes me to have to turn a 1:M link into a 1:1 link in the other direction. Any suggestions? (Incidentally, the documentation refers to an older interface that lacks the graphical point and click way of creating the structure of the set - I wonder if the more graphical interface is part of the problem? I've no idea how long it's been around.).
2 - In the inherited database I have a memo field containing bitmap photographs. I'd like to display them in a form field, but it doesn't work simply by referencing the field in the form. Another memo field containing text does get displayed. Is there a function that needs to be applied to the bitmap data, or some other manipulation that has to take place?
I've done a lot of searching to solve these problems myself before posting here, but I may very well have looked in the wrong places, or phrased searches poorly. This is my first forum post, so forgive me if the content is inappropriate in any way.
Thanks,
Mike
1 - I'm trying to create a set involving "line item".dbf, invoice.dbf, and "buyer data".dbf. Invoice is the root, and buyer data, and line item are each sub-tables of invoice. All is ok until I try to add "line item". Everything seems OK except that no list of columns pops up to let me create the link between invoice and line item. I've checked column data types , etc. and it all seems ok. I don't get any sort of error message, just no selection of columns to link on. If I make line item to root I can make the links, however, that causes me to have to turn a 1:M link into a 1:1 link in the other direction. Any suggestions? (Incidentally, the documentation refers to an older interface that lacks the graphical point and click way of creating the structure of the set - I wonder if the more graphical interface is part of the problem? I've no idea how long it's been around.).
2 - In the inherited database I have a memo field containing bitmap photographs. I'd like to display them in a form field, but it doesn't work simply by referencing the field in the form. Another memo field containing text does get displayed. Is there a function that needs to be applied to the bitmap data, or some other manipulation that has to take place?
I've done a lot of searching to solve these problems myself before posting here, but I may very well have looked in the wrong places, or phrased searches poorly. This is my first forum post, so forgive me if the content is inappropriate in any way.
Thanks,
Mike
Comment